APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 12: pay_balance_dimensions pbd

8: CURSOR csr_get_def_bal_id(p_bal_name IN varchar2) is
9: select pdb.defined_balance_id
10: from pay_balance_types pbt,
11: pay_defined_balances pdb,
12: pay_balance_dimensions pbd
13: where pbt.balance_type_id = pdb.balance_type_id
14: and pbt.balance_name = p_bal_name
15: and pdb.balance_dimension_id = pbd.balance_dimension_id
16: and pbd.dimension_name in ('_ASG_YTD_MTH','_ASG_YTD_BON')

Line 24: pay_balance_dimensions pbd

20: CURSOR csr_get_def_bal_id_ytd(p_bal_name IN varchar2) is
21: select pdb.defined_balance_id
22: from pay_balance_types pbt,
23: pay_defined_balances pdb,
24: pay_balance_dimensions pbd
25: where pbt.balance_type_id = pdb.balance_type_id
26: and pbt.balance_name = p_bal_name
27: and pdb.balance_dimension_id = pbd.balance_dimension_id
28: and pbd.dimension_name = '_ASG_YTD'