DBA Data[Home] [Help]

APPS.PAY_NL_WW_ADJUSTMENTS dependencies on HR_NL_ORG_INFO

Line 204: SELECT distinct hr_nl_org_info.GET_SI_PROVIDER_INFO(paa.organization_id, c_si_type, paa.assignment_id) si_provider_id

200:
201: --Cursor for getting all SI providers for the given SI type for that person
202:
203: CURSOR csr_get1(c_si_type VARCHAR2, c_assignment_action_id NUMBER) IS
204: SELECT distinct hr_nl_org_info.GET_SI_PROVIDER_INFO(paa.organization_id, c_si_type, paa.assignment_id) si_provider_id
205: FROM
206: per_all_assignments_f paa,
207: per_all_assignments_f paa1,
208: pay_assignment_actions pac

Line 213: AND hr_nl_org_info.GET_SI_PROVIDER_INFO(paa.organization_id, c_si_type, paa.assignment_id) <> -1;

209: WHERE
210: pac.assignment_action_id=c_assignment_action_id
211: AND paa1.assignment_id = pac.assignment_id
212: AND paa1.person_id = paa.person_id
213: AND hr_nl_org_info.GET_SI_PROVIDER_INFO(paa.organization_id, c_si_type, paa.assignment_id) <> -1;
214:
215: --Local Variables
216: i NUMBER := 1;
217: v_csr_get1 csr_get1%ROWTYPE;