DBA Data[Home] [Help]

APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 644: pay_element_entries_f peef1,

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

Line 645: pay_element_entries_f peef2,

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

Line 694: pay_element_entries_f peef1,

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

Line 695: pay_element_entries_f peef2,

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

Line 739: pay_element_entries_f peef,

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

Line 839: pay_element_entries_f peef,

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,
842: per_all_people_f papf
843: WHERE

Line 873: pay_element_entries_f peef,

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

Line 991: pay_element_entries_f peef,

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

Line 1024: pay_element_entries_f peef,

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

Line 1148: pay_element_entries_f peef,

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

Line 1184: pay_element_entries_f peef,

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

Line 1368: pay_element_entries_f peef1,

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

Line 1369: pay_element_entries_f peef2,

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

Line 1755: pay_element_entries_f peef,

1751: select max(decode(trim(peevf.input_value_id),p_input_value.type_id,screen_entry_value, null)) deo_type,
1752: max(decode(trim(peevf.input_value_id),p_input_value.ndr_id,screen_entry_value, null)) deo_ndr,
1753: max(decode(trim(peevf.input_value_id),p_input_value.override_freq_id,screen_entry_value, null)) override_freq
1754: from pay_element_entry_values_f peevf,
1755: pay_element_entries_f peef,
1756: pay_element_types_f petf
1757: where
1758: peef.element_type_id = petf.element_type_id
1759: and peef.element_entry_id = peevf.element_entry_id