eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 644: pay_element_entry_values_f peev1,

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
648: and papf.person_id = paaf1.person_id

Line 645: pay_element_entry_values_f peev2,

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
648: and papf.person_id = paaf1.person_id
649: and papf.person_id = paaf2.person_id

Line 694: pay_element_entry_values_f peev1,

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
698: and papf.person_id = paaf1.person_id

Line 695: pay_element_entry_values_f peev2,

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
698: and papf.person_id = paaf1.person_id
699: and papf.person_id = paaf2.person_id

Line 738: pay_element_entry_values_f peev

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
742: AND nvl(paaf2.primary_flag, 'N') = 'Y'

Line 838: pay_element_entry_values_f peev,

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
842: p_date_earned BETWEEN paaf1.effective_start_date and paaf1.effective_end_date

Line 839: pay_element_entry_values_f peev1,

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
842: p_date_earned BETWEEN paaf1.effective_start_date and paaf1.effective_end_date
843: AND paaf1.person_id = paaf2.person_id

Line 872: pay_element_entry_values_f peev

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
876: AND nvl(paaf2.primary_flag, 'N') = 'Y'

Line 990: pay_element_entry_values_f peev,

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
994: AND paaf1.person_id = paaf2.person_id

Line 991: pay_element_entry_values_f peev1,

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
994: AND paaf1.person_id = paaf2.person_id
995: AND p_date_earned BETWEEN paaf2.effective_start_date and paaf2.effective_end_date

Line 1023: pay_element_entry_values_f peev

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
1027: AND paaf1.person_id = paaf2.person_id

Line 1147: pay_element_entry_values_f peev,

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
1151: p_date_earned BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date

Line 1148: pay_element_entry_values_f peev1,

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

Line 1183: pay_element_entry_values_f peev

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
1187: AND nvl(paaf2.primary_flag, 'N') = 'Y'

Line 1206: FROM pay_element_entry_values_f peev

1202:
1203:
1204: CURSOR get_value IS
1205: SELECT peev.screen_entry_value
1206: FROM pay_element_entry_values_f peev
1207: WHERE p_date_earned BETWEEN peev.effective_start_date and peev.effective_end_date
1208: AND peev.element_entry_id = l_entry_id
1209: AND peev.input_value_id IN (l_cto_iv_id, l_cto_ntpp_iv_id);
1210:

Line 1211: l_value pay_element_entry_values_f.screen_entry_value%TYPE;

1207: WHERE p_date_earned BETWEEN peev.effective_start_date and peev.effective_end_date
1208: AND peev.element_entry_id = l_entry_id
1209: AND peev.input_value_id IN (l_cto_iv_id, l_cto_ntpp_iv_id);
1210:
1211: l_value pay_element_entry_values_f.screen_entry_value%TYPE;
1212: l_count NUMBER;
1213: l_proc VARCHAR2(50);
1214:
1215: BEGIN

Line 1318: l_main_ref pay_element_entry_values_f.screen_entry_value%TYPE;

1314: p_date_earned IN DATE,
1315: p_reference IN VARCHAR2
1316: ) RETURN VARCHAR2 IS
1317:
1318: l_main_ref pay_element_entry_values_f.screen_entry_value%TYPE;
1319: l_count NUMBER;
1320: l_proc VARCHAR2(50);
1321:
1322: BEGIN

Line 1368: pay_element_entry_values_f peev1,

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
1372: AND paaf2.assignment_id = paaf1.assignment_id

Line 1369: pay_element_entry_values_f peev2 ,

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
1372: AND paaf2.assignment_id = paaf1.assignment_id
1373: and paaf2.payroll_id = ppf.payroll_id