DBA Data[Home] [Help]

APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 230: ,hr_organization_information hoi

226: ,pac.assignment_id
227: FROM pay_accrual_plans pap
228: ,pay_assignment_actions pac
229: ,pay_payroll_actions ppa
230: ,hr_organization_information hoi
231: ,pay_element_links_f pel
232: ,pay_element_entries_f pee
233: ,pay_element_types_f pet
234: WHERE pac.assignment_action_id = p_run_assignment_action_id

Line 585: FROM hr_organization_information hoi

581:
582: CURSOR csr_business_place(p_tax_unit_id NUMBER)
583: IS
584: SELECT hoi.org_information1 business_place
585: FROM hr_organization_information hoi
586: WHERE hoi.organization_id = p_tax_unit_id
587: AND hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION';
588:
589:

Line 591: l_kr_business_place hr_organization_information.org_information1%TYPE;

587: AND hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION';
588:
589:
590: l_ovn NUMBER;
591: l_kr_business_place hr_organization_information.org_information1%TYPE;
592:
593: BEGIN
594:
595: if g_debug then