APPS.GHR_GENERAL dependencies on PER_ASSIGNMENTS_F

Line 151: p_assignment_id in per_assignments_f.assignment_id%type,

147:
148: end get_poi_to_send_ntfn;
149:
150: Procedure ghr_fehb_migrate(
151: p_assignment_id in per_assignments_f.assignment_id%type,
152: p_business_group_id in per_assignments_f.business_group_id%type,
153: p_person_id in per_assignments_f.person_id%type,
154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,

Line 152: p_business_group_id in per_assignments_f.business_group_id%type,

148: end get_poi_to_send_ntfn;
149:
150: Procedure ghr_fehb_migrate(
151: p_assignment_id in per_assignments_f.assignment_id%type,
152: p_business_group_id in per_assignments_f.business_group_id%type,
153: p_person_id in per_assignments_f.person_id%type,
154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,
156: p_option_code in ben_opt_f.short_code%type,

Line 153: p_person_id in per_assignments_f.person_id%type,

149:
150: Procedure ghr_fehb_migrate(
151: p_assignment_id in per_assignments_f.assignment_id%type,
152: p_business_group_id in per_assignments_f.business_group_id%type,
153: p_person_id in per_assignments_f.person_id%type,
154: p_effective_date in Date ,
155: p_health_plan in ben_pl_f.short_code%type,
156: p_option_code in ben_opt_f.short_code%type,
157: p_element_entry_id in pay_element_entries_f.element_entry_id%type,

Line 700: p_assignment_id in per_assignments_f.assignment_id%type,

696: /* 3) Coverage Start date */
697: /* 4) */
698: /* */
699: Procedure ghr_tsp_migrate(
700: p_assignment_id in per_assignments_f.assignment_id%type,
701: p_opt_name in Varchar2,
702: p_opt_val in Number,
703: p_effective_date in Date,
704: p_business_group_id in per_assignments_f.business_group_id%type,

Line 704: p_business_group_id in per_assignments_f.business_group_id%type,

700: p_assignment_id in per_assignments_f.assignment_id%type,
701: p_opt_name in Varchar2,
702: p_opt_val in Number,
703: p_effective_date in Date,
704: p_business_group_id in per_assignments_f.business_group_id%type,
705: p_person_id in per_assignments_f.person_id%type) is
706:
707: l_prog_count number;
708: l_plan_count number;

Line 705: p_person_id in per_assignments_f.person_id%type) is

701: p_opt_name in Varchar2,
702: p_opt_val in Number,
703: p_effective_date in Date,
704: p_business_group_id in per_assignments_f.business_group_id%type,
705: p_person_id in per_assignments_f.person_id%type) is
706:
707: l_prog_count number;
708: l_plan_count number;
709: l_oipl_count number;

Line 1069: p_assignment_id in per_assignments_f.assignment_id%type,

1065:
1066:
1067: /* TSP Catch Up Migration Procedure */
1068: Procedure ghr_tsp_catchup_migrate(
1069: p_assignment_id in per_assignments_f.assignment_id%type,
1070: p_opt_name in Varchar2,
1071: p_opt_val in Number,
1072: p_effective_date in Date,
1073: p_business_group_id in per_assignments_f.business_group_id%type,

Line 1073: p_business_group_id in per_assignments_f.business_group_id%type,

1069: p_assignment_id in per_assignments_f.assignment_id%type,
1070: p_opt_name in Varchar2,
1071: p_opt_val in Number,
1072: p_effective_date in Date,
1073: p_business_group_id in per_assignments_f.business_group_id%type,
1074: p_person_id in per_assignments_f.person_id%type) is
1075:
1076: l_prog_count number;
1077: l_plan_count number;

Line 1074: p_person_id in per_assignments_f.person_id%type) is

1070: p_opt_name in Varchar2,
1071: p_opt_val in Number,
1072: p_effective_date in Date,
1073: p_business_group_id in per_assignments_f.business_group_id%type,
1074: p_person_id in per_assignments_f.person_id%type) is
1075:
1076: l_prog_count number;
1077: l_plan_count number;
1078: l_oipl_count number;