APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PAY_DEFINED_BALANCES

Line 11: pay_defined_balances pdb,

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
15: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 23: pay_defined_balances pdb,

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
27: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 1876: l_def_bal_id pay_defined_balances.defined_balance_id%type ;

1872: P_PVT_SCHOOL_PEN_PREM out nocopy varchar2) -- Bug 9737699
1873: is
1874: --
1875: eff_date date ;
1876: l_def_bal_id pay_defined_balances.defined_balance_id%type ;
1877: --
1878: begin
1879: eff_date := fnd_date.canonical_to_date(P_EFFECTIVE_DATE);
1880: --