[Home] [Help]
483: l_ppath,
484: l_loc_aa_id,
485: l_loc_src_aa_id
486: from pay_run_results prr,
487: pay_assignment_actions paa
488: where prr.run_result_id = l_run_result_id
489: and prr.assignment_action_id = paa.assignment_action_id;
490: --
491: exception
503: select assignment_action_id,
504: source_action_id
505: into l_loc_aa_id,
506: l_loc_src_aa_id
507: from pay_assignment_actions
508: where assignment_action_id = l_loc_src_aa_id;
509: end loop;
510: l_src_asg_act_id := l_loc_aa_id;
511: end if;
597: end;
598: begin
599: select pay_core_utils.get_process_path(assignment_action_id)
600: into l_ppath
601: from pay_assignment_actions
602: where source_action_id = l_src_asg_act_id
603: and run_type_id = eerec.source_run_type
604: and rownum = 1;
605: --
636: l_ppath,
637: l_loc_aa_id,
638: l_loc_src_aa_id
639: from pay_run_results prr,
640: pay_assignment_actions paa
641: where prr.run_result_id = l_run_result_id
642: and prr.assignment_action_id = paa.assignment_action_id;
643: --
644: exception
657: select assignment_action_id,
658: source_action_id
659: into l_loc_aa_id,
660: l_loc_src_aa_id
661: from pay_assignment_actions
662: where assignment_action_id = l_loc_src_aa_id;
663: end loop;
664: l_src_asg_act_id := l_loc_aa_id;
665: end if;
754: end;
755: begin
756: select pay_core_utils.get_process_path(assignment_action_id)
757: into l_ppath
758: from pay_assignment_actions
759: where source_action_id = l_src_asg_act_id
760: and run_type_id = eerec.source_run_type
761: and rownum = 1;
762: --
809: into l_dummy
810: from dual
811: where exists (select ''
812: from pay_payroll_actions ppa,
813: pay_assignment_actions paa
814: where paa.assignment_id = p_object_id
815: and paa.payroll_action_id = ppa.payroll_action_id
816: and action_type = 'L');
817: l_qualifier := 'Y';
888: EE PAY_ELEMENT_ENTRIES_F_N50,
889: ET PAY_ELEMENT_TYPES_F_PK)
890: */
891: DISTINCT ASGT_ACTION.assignment_action_id, EE.element_entry_id
892: FROM pay_assignment_actions ASGT_ACTION,
893: pay_payroll_actions PAY_ACTION,
894: pay_element_entries_f EE,
895: pay_element_types_f ET
896: WHERE ASGT_ACTION.assignment_id = p_asg_id
1021: into l_dummy
1022: from dual
1023: where exists (select ''
1024: from pay_payroll_actions ppa,
1025: pay_assignment_actions paa
1026: where paa.assignment_id = p_object_id
1027: and paa.payroll_action_id = ppa.payroll_action_id
1028: and ppa.action_type = 'Q');
1029: l_qualifier := 'Y';
1085: into l_dummy
1086: from dual
1087: where exists (select ''
1088: from pay_payroll_actions ppa,
1089: pay_assignment_actions paa
1090: where paa.assignment_id = p_object_id
1091: and paa.payroll_action_id = ppa.payroll_action_id
1092: and action_type in ('R', 'Q', 'B', 'V', 'I'));
1093:
1110: --
1111: procedure upg_sparse_matrix_rrvs (p_assignment_id in number)
1112: is
1113: --
1114: type t_asg_act_id is table of pay_assignment_actions.assignment_action_id%type
1115: index by binary_integer;
1116: type date_tab is table of date index by binary_integer;
1117: --
1118: asgt_action_ids t_asg_act_id;
1125: --
1126: cursor c_get_aas (p_assignment_id in number) is
1127: select /*+ ORDERED use_nl(aa pa)*/
1128: aa.assignment_action_id, pa.effective_date
1129: from pay_assignment_actions aa,
1130: pay_payroll_actions pa
1131: where aa.assignment_id = p_assignment_id
1132: and pa.payroll_action_id = aa.payroll_action_id
1133: and pa.action_type in ('R', 'Q', 'B', 'V', 'I');
1312: into l_dummy
1313: from dual
1314: where exists (select ''
1315: from pay_payroll_actions ppa,
1316: pay_assignment_actions paa
1317: where paa.assignment_id = p_object_id
1318: and paa.payroll_action_id = ppa.payroll_action_id
1319: and action_type in ('R', 'Q', 'B', 'I'));
1320: l_qualifier := 'Y';
1368: null)
1369: ) time_definition_id
1370: from pay_element_entries_f pee,
1371: pay_entry_process_details pepd,
1372: pay_assignment_actions paa,
1373: pay_payroll_actions ppa,
1374: per_time_periods ptp,
1375: pay_element_types_f pet
1376: where pee.creator_type in ('RR', 'EE')
1395: 'G', p_std_time_def_id,
1396: null) time_definition_id,
1397: ppa.action_type
1398: from
1399: pay_assignment_actions paa,
1400: pay_payroll_actions ppa,
1401: pay_element_types_f pet,
1402: pay_run_results prr
1403: where paa.assignment_id = p_asg_id