APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 159: from pay_balance_types

155: /* Get the defined_balance_id for the specified balance name and dimension */
156:
157: cursor csr_bal_type_id(cp_bal_name varchar2) is
158: select balance_type_id
159: from pay_balance_types
160: where balance_name = cp_bal_name;
161:
162: cursor csr_def_bal_id(cp_bal_type_id number,
163: cp_bal_dimension varchar2,

Line 177: l_balance_type_id pay_balance_types.balance_type_id%type;

173: or (pbd.legislation_code is null and
174: pbd.business_group_id is not null));
175:
176: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
177: l_balance_type_id pay_balance_types.balance_type_id%type;
178:
179: begin
180:
181: open csr_bal_type_id(p_balance_name);

Line 1953: pay_balance_types pbt,

1949: cursor c_footnote_info(p_balance_name varchar2) is
1950: select distinct pet.element_information19,
1951: pbt1.balance_name
1952: from pay_balance_feeds_f pbf,
1953: pay_balance_types pbt,
1954: pay_balance_types pbt1,
1955: pay_input_values_f piv,
1956: pay_element_types_f pet,
1957: fnd_lookup_values flv

Line 1954: pay_balance_types pbt1,

1950: select distinct pet.element_information19,
1951: pbt1.balance_name
1952: from pay_balance_feeds_f pbf,
1953: pay_balance_types pbt,
1954: pay_balance_types pbt1,
1955: pay_input_values_f piv,
1956: pay_element_types_f pet,
1957: fnd_lookup_values flv
1958: where pbt.balance_name = p_balance_name