DBA Data[Home] [Help]

APPS.PAY_US_PPM_HOOK dependencies on HR_API

Line 152: IF (p_segment3 = hr_api.g_varchar2 or p_segment4 = hr_api.g_varchar2) then

148: and pppm.PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID
149: AND p_effective_date BETWEEN popm.effective_start_date
150: AND popm.effective_end_date;
151:
152: IF (p_segment3 = hr_api.g_varchar2 or p_segment4 = hr_api.g_varchar2) then
153:
154: OPEN CSR_BANK_SEGMENTS;
155: FETCH CSR_BANK_SEGMENTS INTO L_SEGMENT3, L_SEGMENT4;
156: CLOSE CSR_BANK_SEGMENTS;

Line 158: if (p_segment3 <> hr_api.g_varchar2) then

154: OPEN CSR_BANK_SEGMENTS;
155: FETCH CSR_BANK_SEGMENTS INTO L_SEGMENT3, L_SEGMENT4;
156: CLOSE CSR_BANK_SEGMENTS;
157:
158: if (p_segment3 <> hr_api.g_varchar2) then
159: l_segment3 := p_segment3;
160: end if;
161:
162: if (p_segment4 <> hr_api.g_varchar2) then

Line 162: if (p_segment4 <> hr_api.g_varchar2) then

158: if (p_segment3 <> hr_api.g_varchar2) then
159: l_segment3 := p_segment3;
160: end if;
161:
162: if (p_segment4 <> hr_api.g_varchar2) then
163: l_segment4 := p_segment4;
164: end if;
165:
166: end if;

Line 186: if (p_ppm_information1 = hr_api.g_varchar2) then

182: hr_utility.raise_error;
183:
184: end if;
185:
186: if (p_ppm_information1 = hr_api.g_varchar2) then
187: OPEN CSR_PPM_INFORMATION;
188: FETCH CSR_PPM_INFORMATION INTO L_PPM_INFORMATION1, L_PPM_INFORMATION2, L_PPM_INFORMATION3;
189: CLOSE CSR_PPM_INFORMATION;
190: ELSE