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 91: pay_element_types_f ele

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

Line 274: from pay_element_types_f

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

Line 279: l_element_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

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

Line 498: pay_element_types_f pet,

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