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 646: pay_element_entry_values_f peev1,

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

Line 647: pay_element_entry_values_f peev2,

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

Line 696: pay_element_entry_values_f peev1,

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

Line 697: pay_element_entry_values_f peev2,

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

Line 740: pay_element_entry_values_f peev

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

Line 840: pay_element_entry_values_f peev,

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

Line 841: pay_element_entry_values_f peev1,

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

Line 874: pay_element_entry_values_f peev

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

Line 992: pay_element_entry_values_f peev,

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

Line 993: pay_element_entry_values_f peev1,

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

Line 1025: pay_element_entry_values_f peev

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

Line 1149: pay_element_entry_values_f peev,

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

Line 1150: pay_element_entry_values_f peev1,

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

Line 1185: pay_element_entry_values_f peev

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

Line 1208: FROM pay_element_entry_values_f peev

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

Line 1213: l_value pay_element_entry_values_f.screen_entry_value%TYPE;

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

Line 1320: l_main_ref pay_element_entry_values_f.screen_entry_value%TYPE;

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

Line 1370: pay_element_entry_values_f peev1,

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

Line 1371: pay_element_entry_values_f peev2 ,

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

Line 1573: from pay_element_entry_values_f peevf

1569: is
1570: select max(decode(trim(peevf.input_value_id),p_input_value.type_id,screen_entry_value, null)) deo_type,
1571: max(decode(trim(peevf.input_value_id),p_input_value.ndr_id,screen_entry_value, null)) deo_ndr,
1572: max(decode(trim(peevf.input_value_id),p_input_value.override_freq_id,screen_entry_value, null)) override_freq
1573: from pay_element_entry_values_f peevf
1574: where p_element_entry_id = peevf.element_entry_id
1575: and peevf.input_value_id in (p_input_value.type_id ,
1576: p_input_value.ndr_id ,
1577: p_input_value.override_freq_id,

Line 1754: from pay_element_entry_values_f peevf,

1750: is
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