APPS.PAY_KR_WG_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 180: from pay_element_types_f

176: PROCEDURE load_court_orders
177: IS
178: CURSOR csr_etype(p_element_name VARCHAR2) IS
179: SELECT element_type_id
180: from pay_element_types_f
181: where element_name = p_element_name
182: and legislation_code = 'KR'
183: and business_group_id is null
184: and p_date_earned between effective_start_date and effective_end_date

Line 314: ,pay_element_types_f pet

310: CURSOR csr_prev_payout IS
311: SELECT fnd_date.canonical_to_date(prrv.result_value)
312: from pay_run_results prr
313: ,pay_run_result_values prrv
314: ,pay_element_types_f pet
315: ,pay_input_values_f piv
316: where prr.source_id = p_element_entry_id
317: and prr.entry_type IN ('I','E')
318: and prr.status IN ('P')

Line 331: -- Removed join with pay_element_types_f and used the cursor csr_etype

327: and p_date_earned between piv.effective_start_date and piv.effective_end_date
328: order by prr.assignment_action_id desc;
329: --
330: -- Bug : 4859775
331: -- Removed join with pay_element_types_f and used the cursor csr_etype
332: -- to get the element_type_id of 'WG Results'
333: --
334: CURSOR csr_prev_payout_bal_adj(p_element_type_id IN NUMBER) IS
335: SELECT fnd_date.canonical_to_date(prrv.result_value)

Line 2189: pay_element_types_f pet,

2185: from pay_element_entry_values_f peev,
2186: pay_element_entries_f pee,
2187: pay_element_links_f pel,
2188: pay_input_values_f piv,
2189: pay_element_types_f pet,
2190: fnd_sessions ses
2191: where pet.element_name = 'Wage Garnishments'
2192: and pet.legislation_code = 'KR'
2193: and pet.business_group_id IS NULL