DBA Data[Home] [Help]

APPS.PAY_DK_PR_ASG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 254: FROM hr_all_organization_units haou

250:
251: --to fetch the business group name
252: BEGIN
253: SELECT haou.name INTO l_organization_name
254: FROM hr_all_organization_units haou
255: WHERE haou.organization_id=l_business_group_id;
256: EXCEPTION
257: WHEN OTHERS THEN
258: NULL;

Line 723: ,hr_all_organization_units haou

719: per_all_people_f papf
720: ,per_all_assignments_f paaf
721: ,pay_assignment_actions paa
722: ,per_jobs pj
723: ,hr_all_organization_units haou
724: WHERE
725:
726: paa.assignment_action_id = p_assignment_action_id
727: AND paa.assignment_id = paaf.assignment_id

Line 797: l_employer hr_all_organization_units.name%type;

793: PROCEDURE POPULATE_DETAILS(p_payroll_action_id in VARCHAR2 ,
794: p_template_name in VARCHAR2 ,
795: p_xml OUT NOCOPY CLOB ) IS
796:
797: l_employer hr_all_organization_units.name%type;
798: l_orgnumber hr_organization_information.org_information1%type;
799: l_from_date DATE;
800: l_to_date DATE;
801: -- For bug fix 5231458