[Home] [Help]
559:
560: CURSOR get_freq IS
561: SELECT ptpt.number_per_fiscal_year
562: FROM per_all_assignments_f papf,
563: pay_all_payrolls_f pap,
564: per_time_period_types ptpt
565: WHERE papf.assignment_id = p_assignment_id
566: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date
567: AND pap.payroll_id = papf.payroll_id
591:
592: CURSOR get_curr_pay_date IS
593: SELECT nvl(ptp.regular_payment_date , to_date('01-01-0001','DD-MM-YYYY'))
594: FROM per_all_assignments_f papf,
595: pay_all_payrolls_f pap,
596: per_time_periods ptp
597: WHERE papf.assignment_id = p_assignment_id
598: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date
599: AND pap.payroll_id = papf.payroll_id
637: count(*) cnt
638: from per_all_people_f papf,
639: per_all_assignments_f paaf1,
640: per_all_assignments_f paaf2,
641: pay_all_payrolls_f ppf,
642: pay_input_values_f piv1 ,
643: pay_input_values_f piv2,
644: pay_element_entries_f peef1,
645: pay_element_entries_f peef2,
687: count(*) cnt
688: from per_all_people_f papf,
689: per_all_assignments_f paaf1,
690: per_all_assignments_f paaf2,
691: pay_all_payrolls_f ppf,
692: pay_input_values_f piv1 ,
693: pay_input_values_f piv2,
694: pay_element_entries_f peef1,
695: pay_element_entries_f peef2,
733: CURSOR chk_prim_asg(p_asg_tax_ref IN VARCHAR2) IS
734: SELECT 1 cnt
735: FROM per_all_assignments_f paaf1,
736: per_all_assignments_f paaf2,
737: pay_all_payrolls_f ppf,
738: hr_soft_coding_keyflex scl,
739: pay_element_entries_f peef,
740: pay_element_entry_values_f peev
741: WHERE paaf1.assignment_id = p_assignment_id
833: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) is
834: SELECT ppf.payroll_id
835: FROM per_all_assignments_f paaf1,
836: per_all_assignments_f paaf2,
837: pay_all_payrolls_f ppf,
838: hr_soft_coding_keyflex scl,
839: pay_element_entries_f peef,
840: pay_element_entry_values_f peev,
841: pay_element_entry_values_f peev1,
867: CURSOR get_prim_payroll_id(p_asg_tax_ref VARCHAR2) IS
868: SELECT ppf.payroll_id
869: FROM per_all_assignments_f paaf1,
870: per_all_assignments_f paaf2,
871: pay_all_payrolls_f ppf,
872: hr_soft_coding_keyflex scl,
873: pay_element_entries_f peef,
874: pay_element_entry_values_f peev
875: WHERE paaf1.assignment_id = p_assignment_id
985: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2, p_person_id NUMBER) IS
986: SELECT ppf.payroll_id
987: FROM per_all_assignments_f paaf1,
988: per_all_assignments_f paaf2,
989: pay_all_payrolls_f ppf,
990: hr_soft_coding_keyflex scl,
991: pay_element_entries_f peef,
992: pay_element_entry_values_f peev,
993: pay_element_entry_values_f peev1,
1018: SELECT ppf.payroll_id
1019: FROM fnd_sessions fs,
1020: per_all_assignments_f paaf1,
1021: per_all_assignments_f paaf2,
1022: pay_all_payrolls_f ppf,
1023: hr_soft_coding_keyflex scl,
1024: pay_element_entries_f peef,
1025: pay_element_entry_values_f peev
1026: WHERE paaf1.assignment_id = p_assignment_id
1142: CURSOR get_main_entry_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) IS
1143: SELECT peef.element_entry_id
1144: FROM per_all_assignments_f paaf1,
1145: per_all_assignments_f paaf2,
1146: pay_all_payrolls_f ppf,
1147: hr_soft_coding_keyflex scl,
1148: pay_element_entries_f peef,
1149: pay_element_entry_values_f peev,
1150: pay_element_entry_values_f peev1,
1178: SELECT peef.element_entry_id
1179: FROM
1180: per_all_assignments_f paaf1,
1181: per_all_assignments_f paaf2,
1182: pay_all_payrolls_f ppf,
1183: hr_soft_coding_keyflex scl,
1184: pay_element_entries_f peef,
1185: pay_element_entry_values_f peev
1186: WHERE paaf1.assignment_id = p_assignment_id
1361: SELECT /*+ ORDERED use_nl(paaf1, paaf2, ppf, piv1, piv2, peef1, peef2, scl)*/
1362: peev2.screen_entry_value main_entry_value
1363: from per_all_assignments_f paaf1,
1364: per_all_assignments_f paaf2,
1365: pay_all_payrolls_f ppf,
1366: pay_input_values_f piv1 ,
1367: pay_input_values_f piv2,
1368: pay_element_entries_f peef1,
1369: pay_element_entries_f peef2,