APPS.GHR_GEN_RPA_NPA dependencies on GHR_PREMIUM_PAY_INDICATORS

Line 1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;

1317: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1318: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1319: l_multi_error BOOLEAN;
1320: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1322: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1323: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1324: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1325: l_to_organization_id per_assignments_f.organization_id%TYPE;

Line 1327: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS

1323: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1324: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1325: l_to_organization_id per_assignments_f.organization_id%TYPE;
1326:
1327: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1328: SELECT ppi.ppi_percentage
1329: FROM ghr_premium_pay_indicators ppi
1330: WHERE code = p_ppi_code;
1331:

Line 1329: FROM ghr_premium_pay_indicators ppi

1325: l_to_organization_id per_assignments_f.organization_id%TYPE;
1326:
1327: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1328: SELECT ppi.ppi_percentage
1329: FROM ghr_premium_pay_indicators ppi
1330: WHERE code = p_ppi_code;
1331:
1332: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1333: SELECT rei_information11 amount

Line 2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;

2059: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
2060: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
2061: l_multi_error BOOLEAN;
2062: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
2064: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
2065: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
2066: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
2067: l_to_organization_id per_assignments_f.organization_id%TYPE;

Line 2071: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS

2067: l_to_organization_id per_assignments_f.organization_id%TYPE;
2068: l_pos_ei_data per_position_extra_info%rowtype;
2069: l_poi VARCHAR2(30);
2070:
2071: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
2072: SELECT ppi.ppi_percentage
2073: FROM ghr_premium_pay_indicators ppi
2074: WHERE code = p_ppi_code;
2075:

Line 2073: FROM ghr_premium_pay_indicators ppi

2069: l_poi VARCHAR2(30);
2070:
2071: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
2072: SELECT ppi.ppi_percentage
2073: FROM ghr_premium_pay_indicators ppi
2074: WHERE code = p_ppi_code;
2075:
2076: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS
2077: SELECT rei_information11 amount