APPS.GHR_GEN_RPA_NPA dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 212: FROM ghr_pa_request_extra_info

208: ,rei_information5
209: ,rei_information6
210: ,rei_information7
211: ,rei_information8
212: FROM ghr_pa_request_extra_info
213: WHERE information_type = 'GHR_US_PAR_GEN_AGENCY_DATA'
214: AND pa_request_id = c_pa_request_id;
215:
216: CURSOR C_CNT_SIGS (p_pa_request_id NUMBER, p_effective_date DATE) IS

Line 1334: FROM ghr_pa_request_extra_info

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
1334: FROM ghr_pa_request_extra_info
1335: WHERE pa_request_id = p_pa_request_id
1336: AND information_type='GHR_US_PAR_MD_DDS_PAY';
1337: BEGIN
1338: p_pa_request_rec_out := p_pa_request_rec_in;

Line 1751: FROM ghr_pa_request_extra_info

1747: ,rei_information5
1748: ,rei_information6
1749: ,rei_information7
1750: ,rei_information8
1751: FROM ghr_pa_request_extra_info
1752: WHERE information_type = 'GHR_US_PAR_GEN_AGENCY_DATA'
1753: AND pa_request_id = c_pa_request_id;
1754:
1755: l_pa_request_rec ghr_pa_requests%rowtype;

Line 2078: FROM ghr_pa_request_extra_info

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
2078: FROM ghr_pa_request_extra_info
2079: WHERE pa_request_id = p_pa_request_id
2080: AND information_type='GHR_US_PAR_MD_DDS_PAY';
2081: BEGIN
2082: p_pa_request_rec_out := p_pa_request_rec_in;