DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PAY_BALANCE_TYPES

Line 10: from pay_balance_types pbt,

6: --------------------------------------------------------------
7:
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

Line 22: from pay_balance_types pbt,

18: and pbd.legislation_code = 'KR';
19:
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