APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 457: FROM pay_balance_types pbt,

453:
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

Line 950: ,pay_balance_types pbt

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
954: AND pbd.business_group_id is null

Line 1689: from pay_balance_types pbt,

1685: -- cursor to get defined balance id
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

Line 1701: from pay_balance_types pbt,

1697: and pbd.legislation_code = 'IE';
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

Line 2423: from pay_balance_types pbt,

2419:
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

Line 2860: FROM pay_balance_types pbt,

2856:
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

Line 4461: ,p_balance_name pay_balance_types.balance_name%TYPE

4457:
4458: /* Split the cursor to 2 cursors to improve the performace.new parameter is added to reduce the number of
4459: tables involved to 2 from 5 (5005788) */
4460: CURSOR csr_get_def_bal(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
4461: ,p_balance_name pay_balance_types.balance_name%TYPE
4462: ,c_ppsn_flag varchar2) IS
4463: SELECT pai1.action_information2
4464: FROM pay_action_information pai1
4465: WHERE pai1.action_context_type = 'PA'