eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 458: pay_balance_dimensions pbd,

454: CURSOR csr_balance_dimension(p_balance IN CHAR,
455: p_dimension IN CHAR) IS
456: SELECT pdb.defined_balance_id
457: FROM pay_balance_types pbt,
458: pay_balance_dimensions pbd,
459: pay_defined_balances pdb
460: WHERE pdb.balance_type_id = pbt.balance_type_id
461: AND pdb.balance_dimension_id = pbd.balance_dimension_id
462: AND pbt.balance_name = p_balance

Line 949: pay_balance_dimensions pbd

945: -- Modified this cursor, parameterised dimension_name for bug 5591812
946: cursor balance_id (bal_name varchar2, p_dimension_name varchar2) is
947: SELECT pdb.defined_balance_id
948: FROM
949: pay_balance_dimensions pbd
950: ,pay_balance_types pbt
951: ,pay_defined_balances pdb
952: WHERE
953: pbd.dimension_name = p_dimension_name

Line 1690: pay_balance_dimensions pbd,

1686: -- bug 5383808
1687: cursor csr_defined_bal_id(p_balance_name varchar2) is
1688: select defined_balance_id
1689: from pay_balance_types pbt,
1690: pay_balance_dimensions pbd,
1691: pay_defined_balances pdb
1692: where pbt.balance_name = p_balance_name
1693: and pbt.balance_type_id = pdb.balance_type_id
1694: and pbd.database_item_suffix = '_ASG_PAYE_REF_PRSI_RUN'

Line 1702: pay_balance_dimensions pbd,

1698: -- bug 13513882
1699: cursor csr_usc_defined_bal_id(p_balance_name varchar2) is
1700: select defined_balance_id
1701: from pay_balance_types pbt,
1702: pay_balance_dimensions pbd,
1703: pay_defined_balances pdb
1704: where pbt.balance_name = p_balance_name
1705: and pbt.balance_type_id = pdb.balance_type_id
1706: and pbd.database_item_suffix = p_dimension

Line 2424: pay_balance_dimensions pbd,

2420: -- bug 14215867 start
2421: cursor csr_usc_defined_bal_id(p_balance_name varchar2) is
2422: select defined_balance_id
2423: from pay_balance_types pbt,
2424: pay_balance_dimensions pbd,
2425: pay_defined_balances pdb
2426: where pbt.balance_name = p_balance_name
2427: and pbt.balance_type_id = pdb.balance_type_id
2428: and pbd.database_item_suffix = '_PER_PAYE_REF_YTD'

Line 2861: pay_balance_dimensions pbd,

2857: -- Bug 2943335 used balance name as a parameter
2858: CURSOR cur_defined_balance(l_balance_name IN varchar2 ) IS
2859: SELECT pdb.defined_balance_id
2860: FROM pay_balance_types pbt,
2861: pay_balance_dimensions pbd,
2862: pay_defined_balances pdb
2863: WHERE pdb.balance_type_id = pbt.balance_type_id
2864: AND pdb.balance_dimension_id = pbd.balance_dimension_id
2865: AND UPPER(pbt.balance_name) = UPPER(l_balance_name)