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_SF52_PRE_UPDATE dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,

41: -- This procedure retrieve data from HR extra information tables and all other data required for CPDF Validations
42: --
43: Procedure populate_record_groups
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508

Line 137: from ghr_pa_request_extra_info

133: -- Cursor to select the Payrollname ,as entered by the user from the SF52 Extra Information.
134:
135: Cursor c_payroll_name is
136: select rei_information3 payroll_name
137: from ghr_pa_request_extra_info
138: where pa_request_id = p_pa_request_rec.pa_request_id
139: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
140:
141: -- Cursor to select the Rating Details of the person, required for CPDFs and for update to HR

Line 161: from ghr_pa_request_extra_info

157: rei_information16 appr_sys_ident,
158: rei_information17 optional_info,
159: rei_information18 performance_rating_points,
160: rei_information19 app_starts
161: from ghr_pa_request_extra_info
162: where pa_request_id = p_pa_request_rec.pa_request_id
163: and information_type = 'GHR_US_PAR_PERF_APPRAISAL';
164:
165: -- cursor to select the Conduct Performace of the person. (is it required for CPDFs??, sureis required for the reqd_Check)

Line 877: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei

873: WHERE par.pa_request_id = c_request_id;
874:
875: CURSOR c2 (c_request_id number) is
876: SELECT par.pa_request_id, par.altered_pa_request_id, pei.rei_information3
877: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei
878: WHERE par.pa_request_id = pei.pa_request_id
879: AND pei.pa_request_id = c_request_id
880: AND pei.information_type = 'GHR_US_PAR_TERM_RET_GRADE';
881:

Line 1675: from ghr_pa_request_extra_info

1671: pos.effective_start_date and pos.effective_end_date;
1672:
1673: Cursor c_pa_request_extra_info (l_information_type varchar2) is
1674: Select *
1675: from ghr_pa_request_extra_info
1676: where pa_request_id = p_pa_request_rec.pa_request_id
1677: and information_type = l_information_type;
1678:
1679: --

Line 1769: from ghr_pa_request_extra_info

1765: and ppf.effective_end_date;
1766:
1767: /*Cursor c_pa_request_extra_info (l_information_type varchar2) is
1768: Select rei_information4,rei_information8
1769: from ghr_pa_request_extra_info
1770: where pa_request_id = p_pa_request_rec.pa_request_id
1771: and information_type = l_information_type; */
1772: --
1773: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;

Line 1773: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;

1769: from ghr_pa_request_extra_info
1770: where pa_request_id = p_pa_request_rec.pa_request_id
1771: and information_type = l_information_type; */
1772: --
1773: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1774: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/
1775: l_student_loan_repay ghr_api.student_loan_repay_type;
1776:
1777: --Bug 6881863

Line 1774: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/

1770: where pa_request_id = p_pa_request_rec.pa_request_id
1771: and information_type = l_information_type; */
1772: --
1773: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1774: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/
1775: l_student_loan_repay ghr_api.student_loan_repay_type;
1776:
1777: --Bug 6881863
1778: l_calc_table_id pay_user_tables.user_table_id%type;

Line 2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,

2189: --
2190: PROCEDURE Process_Non_Sf52_Extra_Info
2191: --
2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,

Line 2262: l_pa_request_ei_rec ghr_pa_request_extra_info%rowtype;

2258: l_proc varchar2(70) := 'Process_non_sf52_extra_info';
2259: l_noa_code ghr_nature_of_actions.code%type;
2260: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
2261: l_information_type ghr_pa_request_info_types.information_type%type;
2262: l_pa_request_ei_rec ghr_pa_request_extra_info%rowtype;
2263: p_extra_info_agency_rec ghr_api.extra_info_rec_type;
2264: l_session ghr_history_api.g_session_var_type;
2265: l_multiple_error_flag boolean;
2266: -- Bug#5668878

Line 2287: from ghr_pa_request_extra_info

2283: AND NVL(nfa.end_date_active,p_pa_request_rec.effective_date);
2284: --
2285: Cursor c_pa_request_extra_info is
2286: Select *
2287: from ghr_pa_request_extra_info
2288: where pa_request_id = p_pa_request_rec.pa_request_id
2289: and information_type = l_information_type;
2290:
2291: --Bug # 5584845

Line 2294: from ghr_pa_request_extra_info

2290:
2291: --Bug # 5584845
2292: Cursor c_pa_term_rg_extra_info is
2293: Select *
2294: from ghr_pa_request_extra_info
2295: where pa_request_id = p_pa_request_rec.pa_request_id
2296: and information_type = l_information_type
2297: and fnd_date.canonical_to_date(rei_information6) = (select MIN (NVL(fnd_date.canonical_to_date(rei_information6),p_pa_request_rec.effective_date) )
2298: FROM ghr_pa_request_extra_info

Line 2298: FROM ghr_pa_request_extra_info

2294: from ghr_pa_request_extra_info
2295: where pa_request_id = p_pa_request_rec.pa_request_id
2296: and information_type = l_information_type
2297: and fnd_date.canonical_to_date(rei_information6) = (select MIN (NVL(fnd_date.canonical_to_date(rei_information6),p_pa_request_rec.effective_date) )
2298: FROM ghr_pa_request_extra_info
2299: WHERE pa_request_id = p_pa_request_rec.pa_request_id
2300: AND information_type = l_information_type);
2301:
2302:

Line 2309: l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type := p_pos_grp1.payroll_office_id;

2305: l_organization_structure_id per_position_extra_info.poei_information5%type := p_pos_grp1.organization_structure_id;
2306: l_positions_organization per_position_extra_info.poei_information21%type := p_pos_grp1.positions_organization;
2307: l_organization_function_code per_position_extra_info.poei_information4%type := p_pos_grp2.organization_function_code;
2308: l_personnel_office_id per_position_extra_info.poei_information3%type := p_pos_grp1.personnel_office_id;
2309: l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type := p_pos_grp1.payroll_office_id;
2310: -- End Bug 3260890
2311:
2312: -- Bug# 4672772 Begin
2313:

Line 3679: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei

3675: Function fetch_extra_info_id (p_request_id number)
3676: return number is
3677: CURSOR c2 (c_request_id number) is
3678: SELECT par.pa_request_id, par.altered_pa_request_id, pei.rei_information3
3679: FROM ghr_pa_requests par, ghr_pa_request_extra_info pei
3680: WHERE par.pa_request_id = pei.pa_request_id(+)
3681: AND pei.pa_request_id = c_request_id
3682: AND pei.information_type = 'GHR_US_PAR_TERM_RET_GRADE';
3683: