APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 371: pay_balance_dimensions pbd,

367: CURSOR csr_balance_dimension(p_balance IN CHAR,
368: p_dimension IN CHAR) IS
369: SELECT pdb.defined_balance_id
370: FROM pay_balance_types pbt,
371: pay_balance_dimensions pbd,
372: pay_defined_balances pdb
373: WHERE pdb.balance_type_id = pbt.balance_type_id
374: AND pdb.balance_dimension_id = pbd.balance_dimension_id
375: AND pbt.balance_name = p_balance

Line 749: pay_balance_dimensions pbd

745: -- Modified this cursor, parameterised dimension_name for bug 5591812
746: cursor balance_id (bal_name varchar2, p_dimension_name varchar2) is
747: SELECT pdb.defined_balance_id
748: FROM
749: pay_balance_dimensions pbd
750: ,pay_balance_types pbt
751: ,pay_defined_balances pdb
752: WHERE
753: pbd.dimension_name = p_dimension_name

Line 1425: pay_balance_dimensions pbd,

1421: -- bug 5383808
1422: cursor csr_defined_bal_id(p_balance_name varchar2) is
1423: select defined_balance_id
1424: from pay_balance_types pbt,
1425: pay_balance_dimensions pbd,
1426: pay_defined_balances pdb
1427: where pbt.balance_name = p_balance_name
1428: and pbt.balance_type_id = pdb.balance_type_id
1429: and pbd.database_item_suffix = '_ASG_PAYE_REF_PRSI_RUN'

Line 2194: pay_balance_dimensions pbd,

2190: -- Bug 2943335 used balance name as a parameter
2191: CURSOR cur_defined_balance(l_balance_name IN varchar2 ) IS
2192: SELECT pdb.defined_balance_id
2193: FROM pay_balance_types pbt,
2194: pay_balance_dimensions pbd,
2195: pay_defined_balances pdb
2196: WHERE pdb.balance_type_id = pbt.balance_type_id
2197: AND pdb.balance_dimension_id = pbd.balance_dimension_id
2198: AND UPPER(pbt.balance_name) = UPPER(l_balance_name)