DBA Data[Home] [Help]

APPS.PAY_CA_RULES dependencies on FND_TERRITORIES

Line 378: from pay_action_information pai,fnd_territories ft

374: payroll_action_id = p_payroll_action_id;
375:
376: CURSOR get_employee_country (CP_ASSIGNMENT_ACTION_ID IN NUMBER) IS
377: select ft.nls_territory
378: from pay_action_information pai,fnd_territories ft
379: where pai.action_context_id = cp_assignment_action_id
380: and pai.action_information_category='ADDRESS DETAILS'
381: and ft.territory_code=pai.action_information13;
382:

Line 385: from pay_action_information pai,fnd_territories ft

381: and ft.territory_code=pai.action_information13;
382:
383: CURSOR get_employer_country (CP_ASSIGNMENT_ACTION_ID IN NUMBER) IS
384: select DISTINCT ft.nls_territory
385: from pay_action_information pai,fnd_territories ft
386: where pai.action_context_id =
387: (SELECT payroll_action_id
388: FROM pay_assignment_actions
389: WHERE assignment_action_id = cp_assignment_action_id)