APPS.GHR_GEN_RPA_NPA dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 162: FROM ghr_pa_request_extra_info

158: ,rei_information5
159: ,rei_information6
160: ,rei_information7
161: ,rei_information8
162: FROM ghr_pa_request_extra_info
163: WHERE information_type = 'GHR_US_PAR_GEN_AGENCY_DATA'
164: AND pa_request_id = c_pa_request_id;
165:
166: CURSOR C_CNT_SIGS (p_pa_request_id NUMBER, p_effective_date DATE) IS

Line 1107: FROM ghr_pa_request_extra_info

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
1107: FROM ghr_pa_request_extra_info
1108: WHERE pa_request_id = p_pa_request_id
1109: AND information_type='GHR_US_PAR_MD_DDS_PAY';
1110: BEGIN
1111: p_pa_request_rec_out := p_pa_request_rec_in;

Line 1518: FROM ghr_pa_request_extra_info

1514: ,rei_information5
1515: ,rei_information6
1516: ,rei_information7
1517: ,rei_information8
1518: FROM ghr_pa_request_extra_info
1519: WHERE information_type = 'GHR_US_PAR_GEN_AGENCY_DATA'
1520: AND pa_request_id = c_pa_request_id;
1521:
1522: l_pa_request_rec ghr_pa_requests%rowtype;

Line 1762: FROM ghr_pa_request_extra_info

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
1762: FROM ghr_pa_request_extra_info
1763: WHERE pa_request_id = p_pa_request_id
1764: AND information_type='GHR_US_PAR_MD_DDS_PAY';
1765: BEGIN
1766: p_pa_request_rec_out := p_pa_request_rec_in;