APPS.GHR_GEN_RPA_NPA dependencies on GHR_PREMIUM_PAY_INDICATORS

Line 1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;

1090: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1091: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1092: l_multi_error BOOLEAN;
1093: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1095: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1096: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1097: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1098: l_to_organization_id per_assignments_f.organization_id%TYPE;

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

1096: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1097: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1098: l_to_organization_id per_assignments_f.organization_id%TYPE;
1099:
1100: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1101: SELECT ppi.ppi_percentage
1102: FROM ghr_premium_pay_indicators ppi
1103: WHERE code = p_ppi_code;
1104:

Line 1102: FROM ghr_premium_pay_indicators ppi

1098: l_to_organization_id per_assignments_f.organization_id%TYPE;
1099:
1100: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1101: SELECT ppi.ppi_percentage
1102: FROM ghr_premium_pay_indicators ppi
1103: WHERE code = p_ppi_code;
1104:
1105: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1106: SELECT rei_information11 amount

Line 1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;

1743: l_auo_amount ghr_pa_requests.to_au_overtime%TYPE;
1744: l_availability_amt ghr_pa_requests.to_availability_pay%TYPE;
1745: l_multi_error BOOLEAN;
1746: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1748: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1749: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1750: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1751: l_to_organization_id per_assignments_f.organization_id%TYPE;

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

1751: l_to_organization_id per_assignments_f.organization_id%TYPE;
1752: l_pos_ei_data per_position_extra_info%rowtype;
1753: l_poi VARCHAR2(30);
1754:
1755: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1756: SELECT ppi.ppi_percentage
1757: FROM ghr_premium_pay_indicators ppi
1758: WHERE code = p_ppi_code;
1759:

Line 1757: FROM ghr_premium_pay_indicators ppi

1753: l_poi VARCHAR2(30);
1754:
1755: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1756: SELECT ppi.ppi_percentage
1757: FROM ghr_premium_pay_indicators ppi
1758: WHERE code = p_ppi_code;
1759:
1760: CURSOR get_mddds_amount(p_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1761: SELECT rei_information11 amount