APPS.PAY_OPM_BUS dependencies on PAY_DEFINED_BALANCES

Line 1135: -- row on the parent PAY_DEFINED_BALANCES table.

1131: -- ----------------------------------------------------------------------------
1132: --
1133: -- Description:
1134: -- Check that the defined_balance_id is not null and that it refers to a
1135: -- row on the parent PAY_DEFINED_BALANCES table.
1136: --
1137: -- Pre-Requisites:
1138: -- None
1139: --

Line 1166: from pay_defined_balances db,

1162: l_dummy number;
1163: --
1164: cursor csr_def_bal_id_exists is
1165: select db.defined_balance_id
1166: from pay_defined_balances db,
1167: pay_balance_dimensions bd,
1168: pay_balance_types bt
1169: where nvl(db.business_group_id,p_business_group_id) = p_business_group_id
1170: and ((db.legislation_code is null)

Line 1209: -- Check payment_type_id is a valid entry within PAY_DEFINED_BALANCES.

1205: if (p_org_payment_method_id is null and p_defined_balance_id is not null) then
1206: --
1207: hr_utility.set_location(l_proc,20);
1208: --
1209: -- Check payment_type_id is a valid entry within PAY_DEFINED_BALANCES.
1210: --
1211: open csr_def_bal_id_exists;
1212: fetch csr_def_bal_id_exists into l_dummy;
1213: if ((csr_def_bal_id_exists%notfound) or (l_dummy<>p_defined_balance_id)) then