DBA Data[Home] [Help]

APPS.GHR_US_NFC_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: g_person_id per_all_assignments_f.person_id%type;

8: g_conc_request_id number;
9: g_legislation_code per_business_groups.legislation_code%type;
10: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%type;
11: g_business_group_id per_business_groups.business_group_id%type;
12: g_person_id per_all_assignments_f.person_id%type;
13: g_effective_date date;
14: g_ext_start_dt date;
15: g_ext_end_dt date;
16: g_auth_date VARCHAR2(24);

Line 363: (p_assignment_id in per_all_assignments_f.assignment_id%type

359: -- ~ for the Personnel Action Records like RPA, Remarks, Awards and Address. This
360: -- ~ function would return (Y)es or (N)o.
361: -- =============================================================================
362: function Evaluate_Person_Inclusion
363: (p_assignment_id in per_all_assignments_f.assignment_id%type
364: ,p_effective_date in date
365: ,p_business_group_id in per_all_assignments_f.business_group_id%type
366: ,p_warning_code in out NoCopy varchar2
367: ,p_warning_message in out NoCopy varchar2

Line 365: ,p_business_group_id in per_all_assignments_f.business_group_id%type

361: -- =============================================================================
362: function Evaluate_Person_Inclusion
363: (p_assignment_id in per_all_assignments_f.assignment_id%type
364: ,p_effective_date in date
365: ,p_business_group_id in per_all_assignments_f.business_group_id%type
366: ,p_warning_code in out NoCopy varchar2
367: ,p_warning_message in out NoCopy varchar2
368: ,p_error_code in out NoCopy varchar2
369: ,p_error_message in out NoCopy varchar2