[Home] [Help]
557:
558: CURSOR get_freq IS
559: SELECT ptpt.number_per_fiscal_year
560: FROM per_all_assignments_f papf,
561: pay_all_payrolls_f pap,
562: per_time_period_types ptpt
563: WHERE papf.assignment_id = p_assignment_id
564: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date
565: AND pap.payroll_id = papf.payroll_id
589:
590: CURSOR get_curr_pay_date IS
591: SELECT nvl(ptp.regular_payment_date , to_date('01-01-0001','DD-MM-YYYY'))
592: FROM per_all_assignments_f papf,
593: pay_all_payrolls_f pap,
594: per_time_periods ptp
595: WHERE papf.assignment_id = p_assignment_id
596: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date
597: AND pap.payroll_id = papf.payroll_id
635: count(*) cnt
636: from per_all_people_f papf,
637: per_all_assignments_f paaf1,
638: per_all_assignments_f paaf2,
639: pay_all_payrolls_f ppf,
640: pay_input_values_f piv1 ,
641: pay_input_values_f piv2,
642: pay_element_entries_f peef1,
643: pay_element_entries_f peef2,
685: count(*) cnt
686: from per_all_people_f papf,
687: per_all_assignments_f paaf1,
688: per_all_assignments_f paaf2,
689: pay_all_payrolls_f ppf,
690: pay_input_values_f piv1 ,
691: pay_input_values_f piv2,
692: pay_element_entries_f peef1,
693: pay_element_entries_f peef2,
731: CURSOR chk_prim_asg(p_asg_tax_ref IN VARCHAR2) IS
732: SELECT 1 cnt
733: FROM per_all_assignments_f paaf1,
734: per_all_assignments_f paaf2,
735: pay_all_payrolls_f ppf,
736: hr_soft_coding_keyflex scl,
737: pay_element_entries_f peef,
738: pay_element_entry_values_f peev
739: WHERE paaf1.assignment_id = p_assignment_id
831: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) is
832: SELECT ppf.payroll_id
833: FROM per_all_assignments_f paaf1,
834: per_all_assignments_f paaf2,
835: pay_all_payrolls_f ppf,
836: hr_soft_coding_keyflex scl,
837: pay_element_entries_f peef,
838: pay_element_entry_values_f peev,
839: pay_element_entry_values_f peev1,
865: CURSOR get_prim_payroll_id(p_asg_tax_ref VARCHAR2) IS
866: SELECT ppf.payroll_id
867: FROM per_all_assignments_f paaf1,
868: per_all_assignments_f paaf2,
869: pay_all_payrolls_f ppf,
870: hr_soft_coding_keyflex scl,
871: pay_element_entries_f peef,
872: pay_element_entry_values_f peev
873: WHERE paaf1.assignment_id = p_assignment_id
983: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2, p_person_id NUMBER) IS
984: SELECT ppf.payroll_id
985: FROM per_all_assignments_f paaf1,
986: per_all_assignments_f paaf2,
987: pay_all_payrolls_f ppf,
988: hr_soft_coding_keyflex scl,
989: pay_element_entries_f peef,
990: pay_element_entry_values_f peev,
991: pay_element_entry_values_f peev1,
1016: SELECT ppf.payroll_id
1017: FROM fnd_sessions fs,
1018: per_all_assignments_f paaf1,
1019: per_all_assignments_f paaf2,
1020: pay_all_payrolls_f ppf,
1021: hr_soft_coding_keyflex scl,
1022: pay_element_entries_f peef,
1023: pay_element_entry_values_f peev
1024: WHERE paaf1.assignment_id = p_assignment_id
1140: CURSOR get_main_entry_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) IS
1141: SELECT peef.element_entry_id
1142: FROM per_all_assignments_f paaf1,
1143: per_all_assignments_f paaf2,
1144: pay_all_payrolls_f ppf,
1145: hr_soft_coding_keyflex scl,
1146: pay_element_entries_f peef,
1147: pay_element_entry_values_f peev,
1148: pay_element_entry_values_f peev1,
1176: SELECT peef.element_entry_id
1177: FROM
1178: per_all_assignments_f paaf1,
1179: per_all_assignments_f paaf2,
1180: pay_all_payrolls_f ppf,
1181: hr_soft_coding_keyflex scl,
1182: pay_element_entries_f peef,
1183: pay_element_entry_values_f peev
1184: WHERE paaf1.assignment_id = p_assignment_id
1359: SELECT /*+ ORDERED use_nl(paaf1, paaf2, ppf, piv1, piv2, peef1, peef2, scl)*/
1360: peev2.screen_entry_value main_entry_value
1361: from per_all_assignments_f paaf1,
1362: per_all_assignments_f paaf2,
1363: pay_all_payrolls_f ppf,
1364: pay_input_values_f piv1 ,
1365: pay_input_values_f piv2,
1366: pay_element_entries_f peef1,
1367: pay_element_entries_f peef2,