APPS.PAY_AU_PAYSUM_ALLOWANCE dependencies on PAY_BALANCE_TYPES

Line 41: , pay_balance_types pbt

37: select distinct pbt.balance_name
38: , pdb.defined_balance_id
39: , pbt.balance_type_id
40: from pay_element_types_f pet
41: , pay_balance_types pbt
42: , pay_defined_balances pdb
43: where pet.business_group_id = p_business_group_id
44: and pet.element_information_category = 'AU_EARNINGS'
45: and pet.element_information1 = 'Y'

Line 61: CURSOR check_balance_dimension (c_balance_type_id pay_balance_types.balance_type_id%type)

57: )
58: order by 1
59: ;
60:
61: CURSOR check_balance_dimension (c_balance_type_id pay_balance_types.balance_type_id%type)
62: IS
63: select pbt.balance_name
64: ,count(pdb.defined_balance_id) dim_count
65: from

Line 68: , pay_balance_types pbt

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'
72: and pdb.balance_type_id(+) = c_balance_type_id

Line 86: ,pay_balance_types pbt

82: select pbt.balance_name, pbt.balance_type_id
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

Line 106: TYPE rec_balance IS RECORD (balance_name pay_balance_types.balance_name%type);

102: rec_alw_lst get_allowance_balance_lst%rowtype;
103: rec_chk_bal_dim check_balance_dimension%rowtype;
104:
105:
106: TYPE rec_balance IS RECORD (balance_name pay_balance_types.balance_name%type);
107: TYPE tab_check_balance IS TABLE OF rec_balance INDEX BY BINARY_INTEGER;
108: t_chk_bal tab_check_balance;
109: t_chk_bal_lst tab_check_balance;
110:

Line 381: CURSOR get_dimension_le_ytd (c_balance_type_id pay_balance_types.balance_type_id%type) IS

377: p_business_group_name in per_business_groups.name%type,
378: p_mode in varchar2
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'

Line 390: CURSOR get_dimension_le_run (c_balance_type_id pay_balance_types.balance_type_id%type) IS

386: and pbd.balance_dimension_id = pdb.balance_dimension_id
387: and pdb.balance_type_id = c_balance_type_id
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'

Line 561: CURSOR get_run_balance (c_balance_type_id pay_balance_types.balance_type_id%type) IS

557: p_tl_allowance_balance in tab_allowance_balance,
558: p_mode in varchar2
559: ) IS
560:
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

Line 563: from pay_balance_types pbt

559: ) IS
560:
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