APPS.PAY_US_PSD_XML dependencies on PAY_BALANCE_DIMENSIONS

Line 231: pay_balance_dimensions pbd,

227: cp_balance_name in varchar2,
228: cp_balance_dimension in varchar2 ) is
229: select pdb.defined_balance_id
230: from pay_defined_balances pdb,
231: pay_balance_dimensions pbd,
232: pay_balance_types pbt
233: where pbt.balance_name = cp_balance_name
234: and pbd.database_item_suffix= cp_balance_dimension
235: and pbt.balance_type_id = pdb.balance_type_id

Line 2802: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

2798: l_payroll_action_id number;
2799: l_context_no number := 60;
2800: l_count number := 0;
2801: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
2802: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
2803:
2804: /* Local variables to select only those employees those PSD Withheld <>0*/
2805:
2806: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;