APPS.GHR_US_NFC_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 299: ,per_all_assignments_f paa

295: ,ptp.start_date start_date
296: ,ptp.end_date end_date
297: ,paa.position_id
298: FROM per_time_periods ptp
299: ,per_all_assignments_f paa
300: WHERE paa.assignment_id = cp_assignment_id
301: AND paa.business_group_id = cp_business_group_id
302: AND cp_effective_date BETWEEN paa.effective_start_date
303: AND paa.effective_end_date

Line 307: i per_all_assignments_f.business_group_id%TYPE;

303: AND paa.effective_end_date
304: AND paa.payroll_id =ptp.payroll_id
305: AND cp_effective_date BETWEEN ptp.start_date
306: AND ptp.end_date;
307: i per_all_assignments_f.business_group_id%TYPE;
308: l_get_period_num c_get_period_num%ROWTYPE;
309: l_get_period_num_temp c_get_period_num%ROWTYPE;
310: l_start_date DATE;
311: l_end_date DATE;

Line 829: FROM per_all_assignments_f paa

825: IS
826: CURSOR c_get_asg_info
827: IS
828: SELECT position_id
829: FROM per_all_assignments_f paa
830: WHERE paa.assignment_id=p_assignment_id
831: AND paa.business_group_id=p_business_group_id
832: AND p_effective_date BETWEEN paa.effective_start_date
833: and paa.effective_end_date;

Line 6099: (p_assignment_id in per_all_assignments_f.assignment_id%type

6095: -- =============================================================================
6096: -- ~ Evaluate_Formula:
6097: -- =============================================================================
6098: function Evaluate_Person_Inclusion
6099: (p_assignment_id in per_all_assignments_f.assignment_id%type
6100: ,p_effective_date in date
6101: ,p_business_group_id in per_all_assignments_f.business_group_id%type
6102: ,p_warning_code in out NoCopy varchar2
6103: ,p_warning_message in out NoCopy varchar2

Line 6101: ,p_business_group_id in per_all_assignments_f.business_group_id%type

6097: -- =============================================================================
6098: function Evaluate_Person_Inclusion
6099: (p_assignment_id in per_all_assignments_f.assignment_id%type
6100: ,p_effective_date in date
6101: ,p_business_group_id in per_all_assignments_f.business_group_id%type
6102: ,p_warning_code in out NoCopy varchar2
6103: ,p_warning_message in out NoCopy varchar2
6104: ,p_error_code in out NoCopy varchar2
6105: ,p_error_message in out NoCopy varchar2

Line 6115: from per_all_assignments_f paf

6111: ,c_business_group_id in number
6112: ,c_effective_date in date) is
6113: select paf.person_id
6114: ,paf.assignment_type
6115: from per_all_assignments_f paf
6116: where paf.assignment_id = c_assignment_id
6117: and paf.business_group_id = c_business_group_id
6118: and c_effective_date between paf.effective_start_date
6119: and paf.effective_end_date;

Line 6153: j per_all_assignments_f.business_group_id%TYPE;

6149: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
6150: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
6151: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
6152: l_req_params csr_req_params%ROWTYPE;
6153: j per_all_assignments_f.business_group_id%TYPE;
6154: l_value Varchar2(150) ;
6155: l_proc_name constant varchar2(250) := g_proc_name ||'Evaluate_Person_Inclusion';
6156:
6157: begin

Line 6705: i per_all_assignments_f.business_group_id%TYPE;

6701:
6702:
6703: l_proc_name VARCHAR2(150) := g_proc_name ||'.Get_NFC_ConcProg_Information';
6704: l_return_value VARCHAR2(1000);
6705: i per_all_assignments_f.business_group_id%TYPE;
6706: l_period_num per_time_periods.period_num%TYPE;
6707: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
6708: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
6709: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;