DBA Data[Home] [Help]

APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 2329: pay_element_types_f pet

2325: from pay_balance_feeds_f pbf,
2326: pay_balance_types pbt,
2327: pay_balance_types pbt1,
2328: pay_input_values_f piv,
2329: pay_element_types_f pet
2330: where pbt.balance_name = p_balance_name
2331: and pbf.balance_type_id = pbt.balance_type_id
2332: and pbf.input_value_id = piv.input_value_id
2333: and piv.element_type_id = pet.element_type_id

Line 2350: pay_element_types_f pet,

2346: from pay_balance_feeds_f pbf,
2347: pay_balance_types pbt,
2348: pay_balance_types pbt1,
2349: pay_input_values_f piv,
2350: pay_element_types_f pet,
2351: pay_element_entries_f pee,
2352: pay_element_entry_values_f pev
2353: where pbt.balance_name = p_balance_name
2354: and pee.assignment_id = p_each_asgid

Line 2387: pay_element_types_f pet,

2383: select nvl(pet.element_information20,'NOT FOUND'),pbtl.balance_name,rv.result_value
2384: from pay_assignment_actions pa,
2385: pay_payroll_actions ppa,
2386: per_all_assignments_f paf,
2387: pay_element_types_f pet,
2388: pay_run_results r,
2389: pay_run_result_values rv,
2390: pay_input_values_f piv,
2391: pay_balance_feeds_f pbf,