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_TYPES_F

Line 24: PAY_ELEMENT_TYPES_F ele

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
28: and ipv.legislation_code = 'GB'

Line 45: p_element_type_id in PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_Id%TYPE,

41: --
42:
43: PROCEDURE Fetch_Balances(
44: p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,
45: p_element_type_id in PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_Id%TYPE,
46: p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
47: p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,
48: p_itd_balance OUT NOCOPY NUMBER,
49: p_ptd_balance OUT NOCOPY NUMBER

Line 46: p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

42:
43: PROCEDURE Fetch_Balances(
44: p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,
45: p_element_type_id in PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_Id%TYPE,
46: p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
47: p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,
48: p_itd_balance OUT NOCOPY NUMBER,
49: p_ptd_balance OUT NOCOPY NUMBER
50: ) is

Line 64: pay_element_types_f ele

60: p_element_type_id in NUMBER) is
61: select prr.assignment_action_id,
62: prr.source_id
63: from pay_run_results prr,
64: pay_element_types_f ele
65: where prr.assignment_action_id in (
66: SELECT /*+ use_nl(paa,ppa,ptp,ses) */
67: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
68: paa.assignment_action_id),16))

Line 92: pay_element_types_f ele

88: p_element_type_id in NUMBER) is
89: select prr.assignment_action_id,
90: prr.source_id
91: from pay_run_results prr,
92: pay_element_types_f ele
93: where prr.assignment_action_id in (
94: SELECT /*+ use_nl(paa,ppa,ptp,ses) */
95: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
96: paa.assignment_action_id),16))

Line 276: from pay_element_types_f

272: where session_id = userenv('sessionid');
273:
274: cursor c_element_type is
275: select element_type_id
276: from pay_element_types_f
277: where element_name = 'Student Loan'
278: and legislation_code = 'GB';
279:
280: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;

Line 281: l_element_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

277: where element_name = 'Student Loan'
278: and legislation_code = 'GB';
279:
280: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;
281: l_element_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
282: l_create_warning BOOLEAN;
283: l_effective_date DATE;
284:
285: BEGIN

Line 500: pay_element_types_f pet,

496:
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

Line 1560: from pay_element_types_f petf,

1556: select max(decode(trim(pivf.name),'Type',pivf.input_value_id, null)) type_id,
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

Line 1729: from pay_element_types_f petf,

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

Line 1741: from pay_element_types_f petf,

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

Line 1756: pay_element_types_f petf

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
1760: and petf.element_name = p_element_name