DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on BEN_BENEFIT_CONTRIBUTIONS_F

Line 1193: v_coverage_type ben_benefit_contributions_f.coverage_type%type := null;

1189: );
1190: --
1191: fetched_entry_value fetched_entry_value_rec;
1192: --
1193: v_coverage_type ben_benefit_contributions_f.coverage_type%type := null;
1194: v_ER_contr_default ben_benefit_contributions_f.employer_contribution%type := null;
1195: v_EE_contr_default ben_benefit_contributions_f.employee_contribution%type := null;
1196: --
1197: cursor BENEFIT_PLAN_DEFAULTS is

Line 1194: v_ER_contr_default ben_benefit_contributions_f.employer_contribution%type := null;

1190: --
1191: fetched_entry_value fetched_entry_value_rec;
1192: --
1193: v_coverage_type ben_benefit_contributions_f.coverage_type%type := null;
1194: v_ER_contr_default ben_benefit_contributions_f.employer_contribution%type := null;
1195: v_EE_contr_default ben_benefit_contributions_f.employee_contribution%type := null;
1196: --
1197: cursor BENEFIT_PLAN_DEFAULTS is
1198: --

Line 1195: v_EE_contr_default ben_benefit_contributions_f.employee_contribution%type := null;

1191: fetched_entry_value fetched_entry_value_rec;
1192: --
1193: v_coverage_type ben_benefit_contributions_f.coverage_type%type := null;
1194: v_ER_contr_default ben_benefit_contributions_f.employer_contribution%type := null;
1195: v_EE_contr_default ben_benefit_contributions_f.employee_contribution%type := null;
1196: --
1197: cursor BENEFIT_PLAN_DEFAULTS is
1198: --
1199: select employee_contribution,

Line 1202: from ben_benefit_contributions_f

1198: --
1199: select employee_contribution,
1200: employer_contribution
1201: --
1202: from ben_benefit_contributions_f
1203: --
1204: where p_effective_date between effective_start_date
1205: and effective_end_date
1206: and element_type_id = p_element_type_id

Line 1277: -- from ben_benefit_contributions_f.

1273: entry_value_number := set_of_entry_values%rowcount; -- loop index flag
1274: --
1275: -- If the element is a type A benefit plan, then replace the
1276: -- element type/link level defaults with the defaults retrieved
1277: -- from ben_benefit_contributions_f.
1278: --
1279: if p_contributions_used = 'Y' then
1280: --
1281: -- If the element is a type A benefit plan then get the