APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 198: from pay_balance_types

194: /* Get the defined_balance_id for the specified balance name and dimension */
195:
196: cursor csr_bal_type_id(cp_bal_name varchar2) is
197: select balance_type_id
198: from pay_balance_types
199: where balance_name = cp_bal_name;
200:
201: cursor csr_def_bal_id(cp_bal_type_id number,
202: cp_bal_dimension varchar2,

Line 216: l_balance_type_id pay_balance_types.balance_type_id%type;

212: or (pbd.legislation_code is null and
213: pbd.business_group_id is not null));
214:
215: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
216: l_balance_type_id pay_balance_types.balance_type_id%type;
217:
218: begin
219:
220: open csr_bal_type_id(p_balance_name);

Line 2659: pay_balance_types pbt,

2655: cursor c_footnote_info(p_balance_name varchar2) is
2656: select distinct pet.element_information19,
2657: pbt1.balance_name
2658: from pay_balance_feeds_f pbf,
2659: pay_balance_types pbt,
2660: pay_balance_types pbt1,
2661: pay_input_values_f piv,
2662: pay_element_types_f pet,
2663: fnd_lookup_values flv

Line 2660: pay_balance_types pbt1,

2656: select distinct pet.element_information19,
2657: pbt1.balance_name
2658: from pay_balance_feeds_f pbf,
2659: pay_balance_types pbt,
2660: pay_balance_types pbt1,
2661: pay_input_values_f piv,
2662: pay_element_types_f pet,
2663: fnd_lookup_values flv
2664: where pbt.balance_name = p_balance_name