APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 2004: l_balance_name1 pay_balance_types.balance_name%TYPE;

2000: other_info_amount85 number;
2001: -- code ended for Bug 5698016
2002:
2003: box_52_exists varchar2(1) ;
2004: l_balance_name1 pay_balance_types.balance_name%TYPE;
2005: lv_empcode_prov varchar2(20);
2006: lv_employment_code varchar2(20);
2007: lv_serial_number varchar2(30);
2008: ld_date_of_birth date;

Line 2085: pay_balance_types pbt,

2081: cursor c_balance_feed_info (p_balance_name varchar2) is
2082: select nvl(pet.element_information20,'NOT FOUND'),
2083: pbt1.balance_name
2084: from pay_balance_feeds_f pbf,
2085: pay_balance_types pbt,
2086: pay_balance_types pbt1,
2087: pay_input_values_f piv,
2088: pay_element_types_f pet
2089: where pbt.balance_name = p_balance_name

Line 2086: pay_balance_types pbt1,

2082: select nvl(pet.element_information20,'NOT FOUND'),
2083: pbt1.balance_name
2084: from pay_balance_feeds_f pbf,
2085: pay_balance_types pbt,
2086: pay_balance_types pbt1,
2087: pay_input_values_f piv,
2088: pay_element_types_f pet
2089: where pbt.balance_name = p_balance_name
2090: and pbf.balance_type_id = pbt.balance_type_id

Line 2106: pay_balance_types pbt,

2102: select nvl(pet.element_information20,'NOT FOUND'),
2103: pbt1.balance_name,
2104: pev.screen_entry_value
2105: from pay_balance_feeds_f pbf,
2106: pay_balance_types pbt,
2107: pay_balance_types pbt1,
2108: pay_input_values_f piv,
2109: pay_element_types_f pet,
2110: pay_element_entries_f pee,

Line 2107: pay_balance_types pbt1,

2103: pbt1.balance_name,
2104: pev.screen_entry_value
2105: from pay_balance_feeds_f pbf,
2106: pay_balance_types pbt,
2107: pay_balance_types pbt1,
2108: pay_input_values_f piv,
2109: pay_element_types_f pet,
2110: pay_element_entries_f pee,
2111: pay_element_entry_values_f pev