DBA Data[Home] [Help]

APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_REQUESTS_PKG2

Line 3730: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,

3726: ,p_work_schedule => l_dummy_varchar
3727:
3728: );
3729:
3730: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,
3731: nvl(p_effective_date, trunc(sysdate)));
3732:
3733: if (p_derive_to_cols) then
3734: p_sf52_data.to_organization_id := l_organization_id;

Line 3785: p_sf52_data.from_position_org_line1 := ghr_pa_requests_pkg2.get_agency_code_from(

3781: -- p_sf52_data.from_staffing_diff_percentage := l_staffing_diff_percentage;
3782: -- p_sf52_data.from_organization_id := l_organization_id;
3783: END IF;
3784: if (l_noa_family_code = 'APP') then
3785: p_sf52_data.from_position_org_line1 := ghr_pa_requests_pkg2.get_agency_code_from(
3786: p_pa_request_id => p_sf52_data.pa_request_id,
3787: p_noa_id => l_first_noa_id);
3788: else
3789: p_sf52_data.from_position_org_line1 := l_position_org_line1;

Line 3815: ghr_pa_requests_pkg2.get_agency_code_to(

3811: return;
3812: end if;
3813: if (l_first_noa_code = '352') then
3814: p_sf52_data.to_position_org_line1 :=
3815: ghr_pa_requests_pkg2.get_agency_code_to(
3816: p_pa_request_id => p_sf52_data.pa_request_id,
3817: p_noa_id => l_first_noa_id);
3818: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
3819: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 3821: ghr_pa_requests_pkg2.get_agency_code_to(

3817: p_noa_id => l_first_noa_id);
3818: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
3819: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
3820: p_sf52_data.to_position_org_line1 :=
3821: ghr_pa_requests_pkg2.get_agency_code_to(
3822: p_pa_request_id => p_sf52_data.pa_request_id,
3823: p_noa_id => l_second_noa_id);
3824: end if;
3825:

Line 3895: ghr_pa_requests_pkg2.get_agency_code_to(

3891: p_sf52_data.to_pay_basis := l_pay_basis;
3892: p_sf52_data.to_pay_plan := l_pay_plan;
3893: if (l_first_noa_code = '352') then
3894: p_sf52_data.to_position_org_line1 :=
3895: ghr_pa_requests_pkg2.get_agency_code_to(
3896: p_pa_request_id => p_sf52_data.pa_request_id,
3897: p_noa_id => l_first_noa_id);
3898: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
3899: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 3901: ghr_pa_requests_pkg2.get_agency_code_to(

3897: p_noa_id => l_first_noa_id);
3898: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
3899: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
3900: p_sf52_data.to_position_org_line1 :=
3901: ghr_pa_requests_pkg2.get_agency_code_to(
3902: p_pa_request_id => p_sf52_data.pa_request_id,
3903: p_noa_id => l_second_noa_id);
3904: else
3905: p_sf52_data.to_position_org_line1 := l_position_org_line1;

Line 4079: ghr_pa_requests_pkg2.get_agency_code_to(

4075: || p_sf52_data.to_pay_basis ,1);
4076:
4077: if (l_first_noa_code = '352') then
4078: p_sf52_data.to_position_org_line1 :=
4079: ghr_pa_requests_pkg2.get_agency_code_to(
4080: p_pa_request_id => p_sf52_data.pa_request_id,
4081: p_noa_id => l_first_noa_id);
4082: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4083: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 4085: ghr_pa_requests_pkg2.get_agency_code_to(

4081: p_noa_id => l_first_noa_id);
4082: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4083: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
4084: p_sf52_data.to_position_org_line1 :=
4085: ghr_pa_requests_pkg2.get_agency_code_to(
4086: p_pa_request_id => p_sf52_data.pa_request_id,
4087: p_noa_id => l_second_noa_id);
4088: else
4089: p_sf52_data.to_position_org_line1 := l_position_org_line1;