APPS.PAY_KR_WG_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 186: from pay_element_types_f

182: PROCEDURE load_court_orders
183: IS
184: CURSOR csr_etype(p_element_name VARCHAR2) IS
185: SELECT element_type_id
186: from pay_element_types_f
187: where element_name = p_element_name
188: and legislation_code = 'KR'
189: and business_group_id is null
190: and p_date_earned between effective_start_date and effective_end_date

Line 320: ,pay_element_types_f pet

316: CURSOR csr_prev_payout IS
317: SELECT fnd_date.canonical_to_date(prrv.result_value)
318: from pay_run_results prr
319: ,pay_run_result_values prrv
320: ,pay_element_types_f pet
321: ,pay_input_values_f piv
322: where prr.source_id = p_element_entry_id
323: and prr.entry_type IN ('I','E')
324: and prr.status IN ('P')

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

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

Line 2212: pay_element_types_f pet,

2208: from pay_element_entry_values_f peev,
2209: pay_element_entries_f pee,
2210: pay_element_links_f pel,
2211: pay_input_values_f piv,
2212: pay_element_types_f pet,
2213: fnd_sessions ses
2214: where pet.element_name = 'Wage Garnishments'
2215: and pet.legislation_code = 'KR'
2216: and pet.business_group_id IS NULL