APPS.PAY_AU_PAYSUM_ALLOWANCE dependencies on PAY_BALANCE_DIMENSIONS

Line 30: from pay_balance_dimensions

26: ) is
27:
28: CURSOR get_dimension_asg_le_ytd IS
29: select balance_dimension_id
30: from pay_balance_dimensions
31: where dimension_name = '_ASG_LE_YTD'
32: and legislation_code = 'AU'
33: ;
34:

Line 35: CURSOR get_allowance_balance_upg (c_balance_dimension_id pay_balance_dimensions.balance_dimension_id%type)

31: where dimension_name = '_ASG_LE_YTD'
32: and legislation_code = 'AU'
33: ;
34:
35: CURSOR get_allowance_balance_upg (c_balance_dimension_id pay_balance_dimensions.balance_dimension_id%type)
36: IS
37: select distinct pbt.balance_name
38: , pdb.defined_balance_id
39: , pbt.balance_type_id

Line 67: , pay_balance_dimensions pbd

63: select pbt.balance_name
64: ,count(pdb.defined_balance_id) dim_count
65: from
66: pay_defined_balances pdb
67: , pay_balance_dimensions pbd
68: , pay_balance_types pbt
69: where pdb.balance_dimension_id(+) = pbd.balance_dimension_id
70: and pbd.dimension_name in ( '_ASG_LE_YTD', '_ASG_LE_RUN')
71: and pbd.legislation_code = 'AU'

Line 87: ,pay_balance_dimensions pbd

83: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
84: ,pay_balance_attributes pba
85: ,pay_defined_balances pdb
86: ,pay_balance_types pbt
87: ,pay_balance_dimensions pbd
88: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'
89: and pba.attribute_id = pbad.attribute_id
90: and pba.defined_balance_id = pdb.defined_balance_id
91: and pdb.balance_type_id = pbt.balance_type_id

Line 112: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%type;

108: t_chk_bal tab_check_balance;
109: t_chk_bal_lst tab_check_balance;
110:
111: l_business_group_name per_business_groups.name%type;
112: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%type;
113: counter number := 1;
114: counter_lst number :=1;
115: cnt number:= 1;
116: cntl number:= 1;

Line 383: from pay_balance_dimensions pbd, pay_defined_balances pdb

379: ) is
380:
381: CURSOR get_dimension_le_ytd (c_balance_type_id pay_balance_types.balance_type_id%type) IS
382: select pdb.defined_balance_id
383: from pay_balance_dimensions pbd, pay_defined_balances pdb
384: where pbd.dimension_name = '_LE_YTD'
385: and pbd.legislation_code = 'AU'
386: and pbd.balance_dimension_id = pdb.balance_dimension_id
387: and pdb.balance_type_id = c_balance_type_id

Line 392: from pay_balance_dimensions pbd, pay_defined_balances pdb

388: ;
389:
390: CURSOR get_dimension_le_run (c_balance_type_id pay_balance_types.balance_type_id%type) IS
391: select pdb.defined_balance_id
392: from pay_balance_dimensions pbd, pay_defined_balances pdb
393: where pbd.dimension_name = '_LE_RUN'
394: and pbd.legislation_code = 'AU'
395: and pbd.balance_dimension_id = pdb.balance_dimension_id
396: and pdb.balance_type_id = c_balance_type_id

Line 565: ,pay_balance_dimensions pbd

561: CURSOR get_run_balance (c_balance_type_id pay_balance_types.balance_type_id%type) IS
562: select pbt.balance_name, pbd.dimension_name, pdb.defined_balance_id, pdb.save_run_balance
563: from pay_balance_types pbt
564: ,pay_defined_balances pdb
565: ,pay_balance_dimensions pbd
566: where pbt.balance_type_id = pdb.balance_type_id
567: and pbt. balance_type_id = c_balance_type_id
568: and pbd.balance_dimension_id = pdb.balance_dimension_id
569: and pbd.dimension_name in ('_ASG_LE_RUN','_LE_RUN')

Line 574: l_dimension_name_run pay_balance_dimensions.dimension_name%type;

570: and nvl(pdb.save_run_balance, 'N') <> 'Y'
571: order by 1, 2
572: ;
573:
574: l_dimension_name_run pay_balance_dimensions.dimension_name%type;
575: l_found number := 1;
576: error_code number;
577: error_message varchar2(255);
578: