eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on BEN_BENEFIT_CONTRIBUTIONS_F

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

1165: );
1166: --
1167: fetched_entry_value fetched_entry_value_rec;
1168: --
1169: v_coverage_type ben_benefit_contributions_f.coverage_type%type := null;
1170: v_ER_contr_default ben_benefit_contributions_f.employer_contribution%type := null;
1171: v_EE_contr_default ben_benefit_contributions_f.employee_contribution%type := null;
1172: --
1173: cursor BENEFIT_PLAN_DEFAULTS is

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

1166: --
1167: fetched_entry_value fetched_entry_value_rec;
1168: --
1169: v_coverage_type ben_benefit_contributions_f.coverage_type%type := null;
1170: v_ER_contr_default ben_benefit_contributions_f.employer_contribution%type := null;
1171: v_EE_contr_default ben_benefit_contributions_f.employee_contribution%type := null;
1172: --
1173: cursor BENEFIT_PLAN_DEFAULTS is
1174: --

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

1167: fetched_entry_value fetched_entry_value_rec;
1168: --
1169: v_coverage_type ben_benefit_contributions_f.coverage_type%type := null;
1170: v_ER_contr_default ben_benefit_contributions_f.employer_contribution%type := null;
1171: v_EE_contr_default ben_benefit_contributions_f.employee_contribution%type := null;
1172: --
1173: cursor BENEFIT_PLAN_DEFAULTS is
1174: --
1175: select employee_contribution,

Line 1178: from ben_benefit_contributions_f

1174: --
1175: select employee_contribution,
1176: employer_contribution
1177: --
1178: from ben_benefit_contributions_f
1179: --
1180: where p_effective_date between effective_start_date
1181: and effective_end_date
1182: and element_type_id = p_element_type_id

Line 1253: -- from ben_benefit_contributions_f.

1249: entry_value_number := set_of_entry_values%rowcount; -- loop index flag
1250: --
1251: -- If the element is a type A benefit plan, then replace the
1252: -- element type/link level defaults with the defaults retrieved
1253: -- from ben_benefit_contributions_f.
1254: --
1255: if p_contributions_used = 'Y' then
1256: --
1257: -- If the element is a type A benefit plan then get the