APPS.PAY_IN_RULES dependencies on PAY_ELEMENT_ENTRIES_F

Line 68: FROM pay_element_entries_f pee

64: --
65: -- Cursor for fetching the Element Name
66: CURSOR csr_element_name IS
67: SELECT pet.element_name
68: FROM pay_element_entries_f pee
69: ,pay_element_types_f pet
70: WHERE pet.element_type_id = pee.element_type_id
71: AND pee.element_entry_id = p_ee_id;
72: --

Line 76: FROM pay_element_entries_f target

72: --
73: --Cursor for fetching PF Org Id
74: CURSOR csr_get_pf_source IS
75: SELECT hsc.segment2
76: FROM pay_element_entries_f target
77: ,pay_assignment_actions paa
78: ,pay_payroll_actions ppa
79: ,per_assignments_f paf
80: ,hr_soft_coding_keyflex hsc

Line 95: FROM pay_element_entries_f target

91: --
92: --Cursor for fetching PT Org Id
93: CURSOR csr_get_pt_source is
94: SELECT hsc.segment3
95: FROM pay_element_entries_f target
96: ,pay_assignment_actions paa
97: ,pay_payroll_actions ppa
98: ,per_assignments_f paf
99: ,hr_soft_coding_keyflex hsc

Line 114: FROM pay_element_entries_f target

110: --
111: --Cursor for fetching ESI Org Id
112: CURSOR csr_get_esi_source IS
113: SELECT hsc.segment4
114: FROM pay_element_entries_f target
115: ,pay_assignment_actions paa
116: ,pay_payroll_actions ppa
117: ,per_assignments_f paf
118: ,hr_soft_coding_keyflex hsc

Line 133: FROM pay_element_entries_f target

129:
130: --Cursor for fetching fact/Establishment Org Id
131: CURSOR csr_get_lwf_org is
132: SELECT nvl(hsc.segment6,hsc.segment5)
133: FROM pay_element_entries_f target
134: ,pay_assignment_actions paa
135: ,pay_payroll_actions ppa
136: ,per_assignments_f paf
137: ,hr_soft_coding_keyflex hsc

Line 229: FROM pay_element_entries_f pee

225: --
226: -- Cursor for fetching the Element Name
227: CURSOR csr_element_name IS
228: SELECT pet.element_name
229: FROM pay_element_entries_f pee
230: ,pay_element_types_f pet
231: WHERE pet.element_type_id = pee.element_type_id
232: AND pee.element_entry_id = p_ee_id;
233: --

Line 237: FROM pay_element_entries_f target

233: --
234: --Cursor for fetching PT Org Id
235: CURSOR csr_get_pt_org is
236: SELECT hsc.segment3
237: FROM pay_element_entries_f target
238: ,pay_assignment_actions paa
239: ,pay_payroll_actions ppa
240: ,per_assignments_f paf
241: ,hr_soft_coding_keyflex hsc

Line 256: FROM pay_element_entries_f target

252:
253: --Cursor for fetching fact/Establishment Org Id
254: CURSOR csr_get_lwf_org is
255: SELECT nvl(hsc.segment6,hsc.segment5)
256: FROM pay_element_entries_f target
257: ,pay_assignment_actions paa
258: ,pay_payroll_actions ppa
259: ,per_assignments_f paf
260: ,hr_soft_coding_keyflex hsc