DBA Data[Home] [Help]

APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 642: pay_element_entries_f peef1,

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,
644: pay_element_entry_values_f peev1,
645: pay_element_entry_values_f peev2,
646: hr_soft_coding_keyflex scl

Line 643: pay_element_entries_f peef2,

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,
644: pay_element_entry_values_f peev1,
645: pay_element_entry_values_f peev2,
646: hr_soft_coding_keyflex scl
647: where papf.person_id = p_person_id

Line 692: pay_element_entries_f peef1,

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,
694: pay_element_entry_values_f peev1,
695: pay_element_entry_values_f peev2,
696: hr_soft_coding_keyflex scl

Line 693: pay_element_entries_f peef2,

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,
694: pay_element_entry_values_f peev1,
695: pay_element_entry_values_f peev2,
696: hr_soft_coding_keyflex scl
697: where papf.person_id = p_person_id

Line 737: pay_element_entries_f peef,

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
740: AND p_date_earned BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
741: AND paaf1.person_id = paaf2.person_id

Line 837: pay_element_entries_f peef,

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,
840: per_all_people_f papf
841: WHERE

Line 871: pay_element_entries_f peef,

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
874: AND p_date_earned BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
875: AND paaf1.person_id = paaf2.person_id

Line 989: pay_element_entries_f peef,

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,
992: per_all_people_f papf
993: WHERE p_date_earned BETWEEN paaf1.effective_start_date and paaf1.effective_end_date

Line 1022: pay_element_entries_f peef,

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
1025: AND fs.session_id = userenv('sessionid')
1026: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date

Line 1146: pay_element_entries_f peef,

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,
1149: per_all_people_f papf
1150: WHERE --paaf1.assignment_id = p_assignment_id AND

Line 1182: pay_element_entries_f peef,

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
1185: AND p_date_earned BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
1186: AND paaf1.person_id = paaf2.person_id

Line 1366: pay_element_entries_f peef1,

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,
1368: pay_element_entry_values_f peev1,
1369: pay_element_entry_values_f peev2 ,
1370: hr_soft_coding_keyflex scl

Line 1367: pay_element_entries_f peef2,

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,
1368: pay_element_entry_values_f peev1,
1369: pay_element_entry_values_f peev2 ,
1370: hr_soft_coding_keyflex scl
1371: where paaf1.assignment_id = p_assignment_id