APPS.PAY_AU_PAYE_FF dependencies on PAY_BALANCE_DIMENSIONS

Line 900: l_db_item_suffix pay_balance_dimensions.database_item_suffix%type;

896:
897:
898: c_ytd_input_table c_get_ytd_def_bal_ids%rowtype;
899: l_use_le_balances varchar2(50);
900: l_db_item_suffix pay_balance_dimensions.database_item_suffix%type;
901: l_payroll_id number;
902: l_pay_eff_date DATE;
903: l_flag number;
904: l_counter number;

Line 4361: , pay_balance_dimensions pbd

4357: CURSOR get_def_bal_id (p_bal_name IN pay_balance_types.balance_name%TYPE)
4358: IS
4359: select pdb.defined_balance_id defined_balance_id
4360: from pay_balance_types pbt
4361: , pay_balance_dimensions pbd
4362: , pay_defined_balances pdb
4363: where pbt.balance_name = p_bal_name
4364: and pbd.database_item_suffix = '_ASG_LE_PTD'
4365: and pbt.balance_type_id = pdb.balance_type_id

Line 4395: pay_balance_dimensions pbd

4391: ) sort_index,
4392: pdb.defined_balance_id def_bal_id
4393: FROM pay_balance_types pbt,
4394: pay_defined_balances pdb,
4395: pay_balance_dimensions pbd
4396: WHERE pbt.legislation_code = 'AU'
4397: AND pdb.balance_type_id = pbt.balance_type_id
4398: AND pdb.balance_dimension_id = pbd.balance_dimension_id
4399: AND pbd.legislation_code = 'AU'