APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_BALANCE_TYPES

Line 184: ,pay_balance_types pbt

180: ( SELECT DISTINCT NVL(pbt.reporting_name,pbt.balance_name) balance_name,
181: pdb.defined_balance_id def_id
182: FROM pay_element_types_f pet
183: ,per_all_assignments_f paa
184: ,pay_balance_types pbt
185: ,pay_defined_balances pdb
186: ,pay_balance_dimensions pbd
187: -- ,per_periods_of_service pps
188: ,pay_payroll_actions ppa

Line 253: cursor c_allowance_balance(c_balance_type_id pay_balance_types.balance_type_id%type)

249: AND ppa.effective_date
250: BETWEEN pet.effective_start_date AND pet.effective_end_date;
251:
252: /*Bug#4863149 - Introduced a new cursor to get defined balance id's for allowance balances*/
253: cursor c_allowance_balance(c_balance_type_id pay_balance_types.balance_type_id%type)
254: is
255: select nvl(pbt.reporting_name,pbt.balance_name) balance_name, /* Bug 5743196 -Added nvl */
256: pdb.defined_balance_id
257: from pay_balance_types pbt

Line 257: from pay_balance_types pbt

253: cursor c_allowance_balance(c_balance_type_id pay_balance_types.balance_type_id%type)
254: is
255: select nvl(pbt.reporting_name,pbt.balance_name) balance_name, /* Bug 5743196 -Added nvl */
256: pdb.defined_balance_id
257: from pay_balance_types pbt
258: ,pay_defined_balances pdb
259: ,pay_balance_dimensions pbd
260: where pbt.balance_type_id = c_balance_type_id
261: and pdb.balance_type_id = pbt.balance_type_id

Line 588: FROM pay_balance_types pbt,

584: v_assignment_action_id pay_assignment_actions.assignment_id%type) --2610141
585:
586: IS
587: select pay_balance_pkg.get_value(pdb.defined_balance_id, v_assignment_action_id, c_registered_employer,null,null,null,null) --2610141
588: FROM pay_balance_types pbt,
589: pay_defined_balances pdb,
590: pay_balance_dimensions pbd
591: WHERE pbt.legislation_code = 'AU'
592: AND pbt.balance_name = 'Lump Sum E Payments'

Line 748: from pay_balance_types pbt,

744:
745: /* Bug#3004966 - Added two Balances 'Termination Deductions', 'Total_Tax_Deductions'*/
746: CURSOR c_bal_id (c_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS
747: SELECT pbt.balance_name,pbt.balance_type_id,pdb.defined_balance_id
748: from pay_balance_types pbt,
749: pay_defined_balances pdb, --Bug# 3193479
750: pay_balance_dimensions pbd
751: where pbt.legislation_code = 'AU'
752: and pbt.balance_name in

Line 767: l_bal_name pay_balance_types.balance_name%type;

763: AND pdb.legislation_code = 'AU'
764: AND pbd.dimension_name = c_dimension_name;
765:
766: i number;
767: l_bal_name pay_balance_types.balance_name%type;
768: l_bal_id pay_balance_types.balance_type_id%type;
769: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE; --Bug# 3193479
770: c_dimension_name pay_balance_dimensions.dimension_name%TYPE; -- Bug: 3186840
771: g_debug boolean;

Line 768: l_bal_id pay_balance_types.balance_type_id%type;

764: AND pbd.dimension_name = c_dimension_name;
765:
766: i number;
767: l_bal_name pay_balance_types.balance_name%type;
768: l_bal_id pay_balance_types.balance_type_id%type;
769: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE; --Bug# 3193479
770: c_dimension_name pay_balance_dimensions.dimension_name%TYPE; -- Bug: 3186840
771: g_debug boolean;
772:

Line 775: from pay_balance_types pbt,

771: g_debug boolean;
772:
773: Cursor c_fbt_balance IS --Bug#3749530
774: select pdb.defined_balance_id
775: from pay_balance_types pbt,
776: pay_defined_balances pdb,
777: pay_balance_dimensions pbd
778: where pbt.balance_name ='Fringe Benefits'
779: and pbt.balance_type_id = pdb.balance_type_id

Line 1330: FROM pay_balance_types pbt

1326: 'Termination Deductions',6,'Total_Tax_Deductions',7,'Earnings_Total',8,'Leave Payments Marginal',9,
1327: 'CDEP',10,'Other Income',11
1328: ,'Workplace Giving Deductions', 12) sort_index /*4015082 */
1329: , pdb.defined_balance_id
1330: FROM pay_balance_types pbt
1331: , pay_defined_balances pdb
1332: , pay_balance_dimensions pbd
1333: WHERE pbt.legislation_code = 'AU'
1334: AND pbt.balance_name in

Line 1970: from pay_balance_types pbt,

1966:
1967:
1968: Cursor c_fbt_balance is
1969: select pdb.defined_balance_id
1970: from pay_balance_types pbt,
1971: pay_defined_balances pdb,
1972: pay_balance_dimensions pbd
1973: where pbt.balance_name ='Fringe Benefits'
1974: and pbt.balance_type_id = pdb.balance_type_id