APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 2235: l_balance_name1 pay_balance_types.balance_name%TYPE;

2231: box_52_exists varchar2(1) ;
2232: -- box_20_exists added for bug 7611439
2233: box_20_exists varchar2(1) ;
2234:
2235: l_balance_name1 pay_balance_types.balance_name%TYPE;
2236: l_balance_name2 pay_balance_types.balance_name%TYPE; --rgottipa
2237: lv_empcode_prov varchar2(20);
2238: lv_employment_code varchar2(20);
2239: lv_serial_number varchar2(30);

Line 2236: l_balance_name2 pay_balance_types.balance_name%TYPE; --rgottipa

2232: -- box_20_exists added for bug 7611439
2233: box_20_exists varchar2(1) ;
2234:
2235: l_balance_name1 pay_balance_types.balance_name%TYPE;
2236: l_balance_name2 pay_balance_types.balance_name%TYPE; --rgottipa
2237: lv_empcode_prov varchar2(20);
2238: lv_employment_code varchar2(20);
2239: lv_serial_number varchar2(30);
2240: ld_date_of_birth date;

Line 2326: pay_balance_types pbt,

2322: cursor c_balance_feed_info (p_balance_name varchar2) is
2323: select nvl(pet.element_information20,'NOT FOUND'),
2324: pbt1.balance_name
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

Line 2327: pay_balance_types pbt1,

2323: select nvl(pet.element_information20,'NOT FOUND'),
2324: pbt1.balance_name
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

Line 2347: pay_balance_types pbt,

2343: select nvl(pet.element_information20,'NOT FOUND'),
2344: pbt1.balance_name,
2345: pev.screen_entry_value
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,

Line 2348: pay_balance_types pbt1,

2344: pbt1.balance_name,
2345: pev.screen_entry_value
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

Line 2392: pay_balance_types pbt,

2388: pay_run_results r,
2389: pay_run_result_values rv,
2390: pay_input_values_f piv,
2391: pay_balance_feeds_f pbf,
2392: pay_balance_types pbt,
2393: pay_balance_types pbtl
2394: where ppa.payroll_action_id = pa.payroll_action_id
2395: and r.run_result_id=rv.run_result_id
2396: and pet.element_type_id=r.element_type_id

Line 2393: pay_balance_types pbtl

2389: pay_run_result_values rv,
2390: pay_input_values_f piv,
2391: pay_balance_feeds_f pbf,
2392: pay_balance_types pbt,
2393: pay_balance_types pbtl
2394: where ppa.payroll_action_id = pa.payroll_action_id
2395: and r.run_result_id=rv.run_result_id
2396: and pet.element_type_id=r.element_type_id
2397: and r.assignment_action_id=pa.assignment_action_id