APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_BALANCE_DIMENSIONS

Line 242: g_dimension_id pay_balance_dimensions.balance_dimension_id%type;

238: g_debug boolean;
239: g_business_group_id number;
240: g_package constant varchar2(30) := 'pay_au_payment_summary';
241: g_legislation_code constant varchar2(2) := 'AU';
242: g_dimension_id pay_balance_dimensions.balance_dimension_id%type;
243: g_balance_type_id pay_balance_types.balance_type_id%type; /*Bug#5591993*/
244: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
245: --
246: /*

Line 341: , pay_balance_dimensions pbd

337: , 'Invalidity Payments Transitional Not Part of Prev Term',24
338: , 'Invalidity Payments Transitional Part of Prev Term',25) sort_index, /*4015082 ,6192381 */
339: pdb.defined_balance_id defined_balance_id
340: from pay_balance_types pbt
341: , pay_balance_dimensions pbd
342: , pay_defined_balances pdb
343: where pbt.balance_name in ( 'CDEP'
344: , 'Leave Payments Marginal'
345: , 'Lump Sum A Deductions'

Line 384: , pay_balance_dimensions pbd

380: , 'ETP Payments Life Benefit Part of Prev Term',4
381: , 'Lump Sum C Payments',5) sort_index,
382: pdb.defined_balance_id defined_balance_id
383: from pay_balance_types pbt
384: , pay_balance_dimensions pbd
385: , pay_defined_balances pdb
386: where pbt.balance_name in ('ETP Payments Transitional Not Part of Prev Term'
387: ,'ETP Payments Transitional Part of Prev Term'
388: ,'ETP Payments Life Benefit Not Part of Prev Term'

Line 404: from pay_balance_dimensions pbd

400: ** Moved here to avoid having to be executed for each assignment
401: */
402: cursor c_le_ytd_dimension_id is
403: select balance_dimension_id
404: from pay_balance_dimensions pbd
405: where pbd.dimension_name = '_ASG_LE_YTD'
406: and pbd.legislation_code = g_legislation_code;
407: /*Bug#5591993*/
408: -- Cursor to fetch the balance type id for Seeded balance Union Fees which will be

Line 969: pay_balance_dimensions pbd

965: Cursor c_fbt_balance is
966: select pdb.defined_balance_id
967: from pay_balance_types pbt,
968: pay_defined_balances pdb,
969: pay_balance_dimensions pbd
970: where pbt.balance_name ='Fringe Benefits'
971: and pbt.balance_type_id = pdb.balance_type_id
972: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
973: and pbd.legislation_code ='AU'

Line 1364: pay_balance_dimensions pbd

1360: p_registered_employer,
1361: null,null,null,null) --2610141
1362: from pay_balance_types pbt,
1363: pay_defined_balances pdb,
1364: pay_balance_dimensions pbd
1365: where pbt.balance_name = c_balance_name
1366: and pbt.legislation_code = 'AU'
1367: and pbt.balance_type_id = pdb.balance_type_id
1368: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1400: pay_balance_dimensions pbd

1396: p_registered_employer,
1397: null,null,null,null)) --2610141
1398: FROM pay_balance_types pbt,
1399: pay_defined_balances pdb,
1400: pay_balance_dimensions pbd
1401: WHERE pbt.legislation_code = 'AU'
1402: AND pbt.balance_name = 'Lump Sum E Payments'
1403: AND pbt.balance_type_id = pdb.balance_type_id
1404: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2061: ,c_dimension_id pay_balance_dimensions.balance_dimension_id%type

2057: cursor get_allowance_balances
2058: (c_year_start date
2059: ,c_year_end date
2060: ,c_assignment_id pay_assignment_actions.assignment_id%type
2061: ,c_dimension_id pay_balance_dimensions.balance_dimension_id%type
2062: ) IS
2063: select balance_name
2064: , pay_balance_pkg.get_value(def_id,p_max_assignment_action_id,p_registered_employer,null,null,null,null) balance_value
2065: , def_id

Line 2075: --, pay_balance_dimensions pbd

2071: from pay_element_types_f pet
2072: , per_all_assignments_f paa
2073: , pay_balance_types pbt
2074: , pay_defined_balances pdb
2075: --, pay_balance_dimensions pbd
2076: --, per_periods_of_service pps
2077: , pay_payroll_actions ppa
2078: , pay_assignment_actions pac
2079: , pay_run_results prr

Line 2697: ,pay_balance_dimensions pbd

2693: IS
2694: SELECT pdb.defined_balance_id
2695: FROM pay_balance_types pbt
2696: ,pay_defined_balances pdb
2697: ,pay_balance_dimensions pbd
2698: WHERE pbt.balance_name = 'Union Fees'
2699: AND pbt.legislation_code = 'AU'
2700: AND pbd.legislation_code = 'AU'
2701: AND pbt.balance_type_id = pdb.balance_type_id

Line 4698: pay_balance_dimensions pbd

4694: cursor balance_exists is
4695: select pdb.defined_balance_id
4696: from pay_balance_types pbt,
4697: pay_defined_balances pdb,
4698: pay_balance_dimensions pbd
4699: where pbt.balance_name ='Lump Sum C Payments'
4700: and pbt.balance_type_id = pdb.balance_type_id
4701: and pdb.balance_dimension_id = pbd.balance_dimension_id --2501105
4702: and pbd.legislation_code = g_legislation_code