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
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
1207: P_LTCI_PREM_EE out nocopy varchar2) -- Bug 7260606
1208: is
1209: --
1210: eff_date date ;
1211: l_def_bal_id pay_defined_balances.defined_balance_id%type ;
1212: --
1213: begin
1214: eff_date := fnd_date.canonical_to_date(P_EFFECTIVE_DATE);
1215: --