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.

APPS.GHR_NFC_POSITION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 231: ,per_all_assignments_f paa

227: ,ptp.start_date start_date
228: ,ptp.end_date end_date
229: ,paa.position_id
230: FROM per_time_periods ptp
231: ,per_all_assignments_f paa
232: WHERE paa.assignment_id = cp_assignment_id
233: AND paa.business_group_id = cp_business_group_id
234: AND cp_effective_date BETWEEN paa.effective_start_date
235: AND paa.effective_end_date

Line 239: i per_all_assignments_f.business_group_id%TYPE;

235: AND paa.effective_end_date
236: AND paa.payroll_id =ptp.payroll_id
237: AND cp_effective_date BETWEEN ptp.start_date
238: AND ptp.end_date;
239: i per_all_assignments_f.business_group_id%TYPE;
240: l_get_period_num c_get_period_num%ROWTYPE;
241: l_get_period_num_temp c_get_period_num%ROWTYPE;
242: l_start_date DATE;
243: l_end_date DATE;

Line 2739: i PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE;

2735: l_rule VARCHAR2(1);
2736: l_row NUMBER;
2737: l_sequence NUMBER;
2738: l_attribute_name VARCHAR2(80);
2739: i PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE;
2740: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Interface_Attribute_Value';
2741:
2742: BEGIN
2743:

Line 2934: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

2930: -- Position_Sub_Header_Criteria: The Main Sub Header criteria that would be used
2931: -- for the position extract.
2932: -- =============================================================================
2933: FUNCTION Position_Sub_Header_Criteria
2934: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2935: ,p_position_id IN hr_all_positions_f.position_id%TYPE
2936: ,p_warning_message OUT NOCOPY Varchar2
2937: ,p_error_message OUT NOCOPY Varchar2
2938: ) RETURN Varchar2 IS

Line 2946: FROM per_all_assignments_f

2942: (c_position_id IN NUMBER
2943: ,c_effective_date IN DATE
2944: ,c_business_group_id IN NUMBER) IS
2945: SELECT 'X'
2946: FROM per_all_assignments_f
2947: WHERE position_id = c_position_id
2948: AND business_group_id = c_business_group_id
2949: AND c_effective_date BETWEEN effective_start_date
2950: AND effective_end_date;

Line 2956: i per_all_assignments_f.business_group_id%TYPE;

2952:
2953: l_proc_name Varchar2(150) := g_proc_name ||'Position_Sub_Header_Criteria';
2954: l_req_params csr_req_params%ROWTYPE;
2955: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
2956: i per_all_assignments_f.business_group_id%TYPE;
2957: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
2958: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
2959: l_return_value Varchar2(2) :='Y';
2960: l_valid_action Varchar2(2) := 'Y';

Line 3121: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

3117: -- Position_Person_Main_Criteria: The Main criteria that would be used
3118: -- for the position extract.
3119: -- =============================================================================
3120: FUNCTION Position_Person_Main_Criteria
3121: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3122: ,p_effective_date IN Date
3123: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3124: ,p_warning_message OUT NOCOPY Varchar2
3125: ,p_error_message OUT NOCOPY Varchar2

Line 3123: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3119: -- =============================================================================
3120: FUNCTION Position_Person_Main_Criteria
3121: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3122: ,p_effective_date IN Date
3123: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3124: ,p_warning_message OUT NOCOPY Varchar2
3125: ,p_error_message OUT NOCOPY Varchar2
3126: ) RETURN Varchar2 IS
3127:

Line 3132: FROM per_all_assignments_f

3128: CURSOR per_assignment_f_cursor(c_assignment_id IN NUMBER
3129: ,c_effective_date IN DATE
3130: ,c_business_group_id IN NUMBER) IS
3131: SELECT position_id
3132: FROM per_all_assignments_f
3133: WHERE assignment_id = c_assignment_id
3134: AND business_group_id = c_business_group_id
3135: AND c_effective_date BETWEEN effective_start_date
3136: AND effective_end_date;

Line 3139: i per_all_assignments_f.business_group_id%TYPE;

3135: AND c_effective_date BETWEEN effective_start_date
3136: AND effective_end_date;
3137:
3138: l_proc_name Varchar2(150) := g_proc_name ||'Person_Main_Criteria';
3139: i per_all_assignments_f.business_group_id%TYPE;
3140: l_return_value Varchar2(2) :='Y';
3141: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
3142: l_position_id hr_all_positions_f.position_id%TYPE;
3143: l_value Varchar2(150) ;

Line 3344: i per_all_assignments_f.business_group_id%TYPE;

3340: WHERE request_id = c_req_id;
3341:
3342: l_proc_name VARCHAR2(150) := g_proc_name ||'.Get_NFC_ConcProg_Information';
3343: l_return_value VARCHAR2(1000);
3344: i per_all_assignments_f.business_group_id%TYPE;
3345: l_period_num per_time_periods.period_num%TYPE;
3346: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
3347: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
3348: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;

Line 3454: from per_all_assignments_f paf

3450: ,c_ext_rslt_id IN Number
3451: ,c_business_group_id IN VARCHAR2
3452: ,c_effective_date IN VARCHAR2 ) IS
3453: select distinct paf.position_id
3454: from per_all_assignments_f paf
3455: ,ben_ext_rslt_dtl dtl
3456: where dtl.val_71 = paf.position_id
3457: and paf.business_group_id = c_business_group_id
3458: and paf.business_group_id = dtl.business_group_id