APPS.PAY_BAL_ADJUST dependencies on PAY_ELEMENT_ENTRIES_F

Line 527: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

523: l_rr_sparse_jc boolean;
524: l_rule_mode varchar2(30);
525: l_status varchar2(30);
526: l_found boolean;
527: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
528: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
529: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
530: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
531: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;

Line 528: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

524: l_rule_mode varchar2(30);
525: l_status varchar2(30);
526: l_found boolean;
527: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
528: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
529: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
530: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
531: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
532: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;

Line 529: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

525: l_status varchar2(30);
526: l_found boolean;
527: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
528: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
529: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
530: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
531: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
532: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
533: l_period_status per_time_periods.status%TYPE;

Line 530: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

526: l_found boolean;
527: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
528: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
529: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
530: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
531: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
532: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
533: l_period_status per_time_periods.status%TYPE;
534: l_date_on_which_time_served_ok date;

Line 552: FROM pay_element_entries_f ee

548: l_costable_type pay_element_links_f.costable_type%TYPE;
549: --
550: CURSOR c_output_variables IS
551: SELECT ee.object_version_number
552: FROM pay_element_entries_f ee
553: WHERE l_element_entry_id = ee.element_entry_id
554: -- bug 675794, added date condition to select correct row
555: AND l_effective_date BETWEEN ee.effective_start_date
556: AND ee.effective_end_date;

Line 571: FROM pay_element_entries_f ee,

567: AND pas.effective_end_date;
568:
569: CURSOR c_entry_exists IS
570: SELECT 'X'
571: FROM pay_element_entries_f ee,
572: pay_element_types_f et,
573: pay_element_links_f el
574: WHERE el.element_link_id = ee.element_link_id
575: AND el.element_link_id = p_element_link_id

Line 840: update pay_element_entries_f pee

836: -- the entry api doesn't allow us to on insert (which seems odd)
837: -- and don't see the point of going all out to use the
838: -- update API. May re-address when do 'proper' batch version.
839: -- Also, balance_adj_cost_flag is not supported yet by API.
840: update pay_element_entries_f pee
841: set pee.creator_id = l_info.assactid,
842: pee.creator_type = 'B',
843: pee.balance_adj_cost_flag = p_balance_adj_cost_flag
844: where pee.element_entry_id = l_element_entry_id

Line 1129: update pay_element_entries_f pee

1125: -- the entry api doesn't allow us to on insert (which seems odd)
1126: -- and don't see the point of going all out to use the
1127: -- update API. May re-address when do 'proper' batch version.
1128: -- Also, balance_adj_cost_flag is not supported yet by API.
1129: update pay_element_entries_f pee
1130: set pee.creator_id = l_info.assactid,
1131: pee.creator_type = 'B',
1132: pee.balance_adj_cost_flag = p_balance_adj_cost_flag
1133: where pee.element_entry_id = l_element_entry_id

Line 1312: from pay_element_entries_f ee

1308: ee.original_entry_id
1309: into l_element_entry_id,
1310: l_element_link_id,
1311: l_original_entry_id
1312: from pay_element_entries_f ee
1313: where ee.creator_id = p_assignment_action_id
1314: and ee.assignment_id = l_assignment_id
1315: and ee.creator_type='B'
1316: and ee.entry_type = 'B'

Line 1426: from pay_element_entries_f

1422: -- see if entry already exists (i.e a rerun )
1423:
1424: select element_entry_id
1425: into p_entry_id
1426: from pay_element_entries_f
1427: where assignment_id=p_assignment_id
1428: and entry_type='B'
1429: and creator_id=p_assignment_action_id
1430: and p_effdate between effective_start_date and effective_end_date;

Line 1464: update pay_element_entries_f

1460: p_entry_type => 'B',
1461: p_cost_allocation_keyflex_id =>p_costkflx_id,
1462: p_creator_id => p_assignment_action_id);
1463:
1464: update pay_element_entries_f
1465: set balance_adj_cost_flag = p_balcostflg
1466: where element_entry_id = p_entry_id;
1467:
1468: end create_ee;