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_INPUT_VALUES_F

Line 18: l_input_value_id PAY_INPUT_VALUES_F.input_value_id%TYPE;

14: FUNCTION Get_Input_Value_Id(
15: p_name in VARCHAR2,
16: p_effective_date in DATE
17: ) RETURN NUMBER is
18: l_input_value_id PAY_INPUT_VALUES_F.input_value_id%TYPE;
19:
20: BEGIN
21:
22: SELECT ipv.input_value_id INTO l_input_value_id

Line 23: FROM PAY_INPUT_VALUES_F ipv,

19:
20: BEGIN
21:
22: SELECT ipv.input_value_id INTO l_input_value_id
23: FROM PAY_INPUT_VALUES_F ipv,
24: PAY_ELEMENT_TYPES_F ele
25: WHERE ele.element_name = 'Student Loan'
26: and ele.legislation_code = 'GB'
27: AND ipv.name = p_name

Line 501: pay_input_values_f piv

497: CURSOR get_input_value_ids IS
498: SELECT piv.input_value_id
499: FROM fnd_sessions fs,
500: pay_element_types_f pet,
501: pay_input_values_f piv
502: WHERE fs.session_id = userenv('sessionid')
503: AND pet.element_name = p_ele_name
504: AND pet.business_group_id IS NULL
505: AND pet.legislation_code = 'GB'

Line 642: pay_input_values_f piv1 ,

638: from per_all_people_f papf,
639: per_all_assignments_f paaf1,
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,

Line 643: pay_input_values_f piv2,

639: per_all_assignments_f paaf1,
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,

Line 692: pay_input_values_f piv1 ,

688: from per_all_people_f papf,
689: per_all_assignments_f paaf1,
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,

Line 693: pay_input_values_f piv2,

689: per_all_assignments_f paaf1,
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,

Line 1366: pay_input_values_f piv1 ,

1362: peev2.screen_entry_value main_entry_value
1363: from per_all_assignments_f paaf1,
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,

Line 1367: pay_input_values_f piv2,

1363: from per_all_assignments_f paaf1,
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 ,

Line 1446: pay_input_values_f piv ,

1442: SELECT nvl(prrv.result_value,'Unknown')
1443: FROM pay_run_results prr,
1444: pay_run_result_values prrv,
1445: pay_assignment_actions pac,
1446: pay_input_values_f piv ,
1447: pay_payroll_actions ppa
1448: WHERE prr.run_result_id = prrv.run_result_id
1449: AND prr.entry_type = 'E'
1450: AND PRR.source_type IN ('E', 'I')

Line 1561: pay_input_values_f pivf

1557: max(decode(trim(pivf.name),'Order Amount',pivf.input_value_id, null)) ndr_id,
1558: max(decode(trim(pivf.name),'DEO Overriding Frequency',pivf.input_value_id, null)) override_freq_id,
1559: max(decode(trim(pivf.name),'Reference',pivf.input_value_id, null)) reference_id
1560: from pay_element_types_f petf,
1561: pay_input_values_f pivf
1562: where petf.element_type_id = p_element_type_id -- in ('Court Order','Court Order NTPP')
1563: and petf.LEGISLATION_CODE ='GB'
1564: and petf.element_type_id = pivf.element_type_id
1565: and p_date_earned between petf.effective_start_date and petf.effective_end_date

Line 1730: pay_input_values_f pivf

1726: select max(decode(trim(pivf.name),'Type',pivf.input_value_id, null)) type_id,
1727: max(decode(trim(pivf.name),'Order Amount',pivf.input_value_id, null)) ndr_id,
1728: max(decode(trim(pivf.name),'DEO Overriding Frequency',pivf.input_value_id, null)) override_freq_id
1729: from pay_element_types_f petf,
1730: pay_input_values_f pivf
1731: where petf.element_name = p_element_name
1732: and petf.LEGISLATION_CODE ='GB'
1733: and p_date_earned between petf.effective_start_date and petf.effective_end_date
1734: and p_date_earned between pivf.effective_start_date and pivf.effective_end_date;

Line 1742: pay_input_values_f pivf

1738: select max(decode(trim(pivf.name),'Type',pivf.input_value_id, null)) type_id,
1739: max(decode(trim(pivf.name),'Order Amount',pivf.input_value_id, null)) ndr_id,
1740: max(decode(trim(pivf.name),'DEO Overriding Frequency',pivf.input_value_id, null)) override_freq_id
1741: from pay_element_types_f petf,
1742: pay_input_values_f pivf
1743: where petf.element_name = p_element_name -- in ('Court Order','Court Order NTPP')
1744: and petf.LEGISLATION_CODE ='GB'
1745: and petf.element_type_id = pivf.element_type_id
1746: and p_date_earned between petf.effective_start_date and petf.effective_end_date