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 499: pay_input_values_f piv

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

Line 640: pay_input_values_f piv1 ,

636: from per_all_people_f papf,
637: per_all_assignments_f paaf1,
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,

Line 641: pay_input_values_f piv2,

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

Line 690: pay_input_values_f piv1 ,

686: from per_all_people_f papf,
687: per_all_assignments_f paaf1,
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,

Line 691: pay_input_values_f piv2,

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

Line 1364: pay_input_values_f piv1 ,

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

Line 1365: pay_input_values_f piv2,

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

Line 1444: pay_input_values_f piv ,

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