APPS.PAY_DK_PR_ORG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 299: ,hr_all_organization_units haou

295: ,pay_element_types_f petf
296: ,pay_all_payrolls_f ppf
297: ,pay_payroll_actions ppa1
298: ,pay_payroll_actions ppa2
299: ,hr_all_organization_units haou
300: ,pay_action_interlocks pai
301:
302: WHERE
303: paaf.business_group_id = l_business_group_id -- BG Check

Line 398: ,hr_all_organization_units haou

394: ,pay_all_payrolls_f ppf
395: ,pay_payroll_actions ppa1
396: ,pay_payroll_actions ppa2
397: ,pay_element_set_members pesm
398: ,hr_all_organization_units haou
399: ,pay_action_interlocks pai
400:
401: WHERE
402: paaf.business_group_id = l_business_group_id -- BG Check

Line 526: FROM hr_all_organization_units haou

522:
523: --to fetch the business group name
524: BEGIN
525: SELECT haou.name INTO l_business_group_name
526: FROM hr_all_organization_units haou
527: WHERE haou.organization_id=l_business_group_id;
528: EXCEPTION
529: WHEN OTHERS THEN
530: NULL;

Line 536: FROM hr_all_organization_units haou

532:
533: --to fetch the organization name
534: BEGIN
535: SELECT haou.name INTO l_organization_name
536: FROM hr_all_organization_units haou
537: WHERE haou.organization_id=l_organization_id;
538: EXCEPTION
539: WHEN OTHERS THEN
540: NULL;

Line 714: l_employer hr_all_organization_units.name%type;

710:
711: PROCEDURE POPULATE_DETAILS(p_payroll_action_id in VARCHAR2 ,
712: p_template_name in VARCHAR2 ,
713: p_xml OUT NOCOPY CLOB ) IS
714: l_employer hr_all_organization_units.name%type;
715: l_orgnumber hr_organization_information.org_information1%type;
716: l_from_date DATE;
717: l_to_date DATE;
718: -- For bug fix 5231458