DBA Data[Home] [Help]

APPS.PAY_DK_PR_LE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 304: ,hr_all_organization_units haou1

300: ,pay_element_types_f petf
301: ,pay_all_payrolls_f ppf
302: ,pay_payroll_actions ppa1
303: ,pay_payroll_actions ppa2
304: ,hr_all_organization_units haou1
305: ,hr_all_organization_units haou2
306: ,pay_action_interlocks pai
307:
308: WHERE

Line 305: ,hr_all_organization_units haou2

301: ,pay_all_payrolls_f ppf
302: ,pay_payroll_actions ppa1
303: ,pay_payroll_actions ppa2
304: ,hr_all_organization_units haou1
305: ,hr_all_organization_units haou2
306: ,pay_action_interlocks pai
307:
308: WHERE
309: paaf.business_group_id = l_business_group_id -- BG Check

Line 413: ,hr_all_organization_units haou1

409: ,pay_all_payrolls_f ppf
410: ,pay_payroll_actions ppa1
411: ,pay_payroll_actions ppa2
412: ,pay_element_set_members pesm
413: ,hr_all_organization_units haou1
414: ,hr_all_organization_units haou2
415: ,pay_action_interlocks pai
416:
417: WHERE

Line 414: ,hr_all_organization_units haou2

410: ,pay_payroll_actions ppa1
411: ,pay_payroll_actions ppa2
412: ,pay_element_set_members pesm
413: ,hr_all_organization_units haou1
414: ,hr_all_organization_units haou2
415: ,pay_action_interlocks pai
416:
417: WHERE
418: paaf.business_group_id = l_business_group_id -- BG Check

Line 546: FROM hr_all_organization_units haou

542:
543: --to fetch the organization name
544: BEGIN
545: SELECT haou.name INTO l_business_group_name
546: FROM hr_all_organization_units haou
547: WHERE haou.organization_id=l_business_group_id;
548: EXCEPTION
549: WHEN OTHERS THEN
550: NULL;

Line 555: FROM hr_all_organization_units haou

551: END;
552:
553: BEGIN
554: SELECT haou.name INTO l_legal_employer_name
555: FROM hr_all_organization_units haou
556: WHERE haou.organization_id=l_legal_employer_id;
557: EXCEPTION
558: WHEN OTHERS THEN
559: NULL;

Line 736: l_employer hr_all_organization_units.name%type;

732:
733: PROCEDURE POPULATE_DETAILS(p_payroll_action_id in VARCHAR2 ,
734: p_template_name in VARCHAR2 ,
735: p_xml OUT NOCOPY CLOB ) IS
736: l_employer hr_all_organization_units.name%type;
737: l_orgnumber hr_organization_information.org_information1%type;
738: l_from_date DATE;
739: l_to_date DATE;
740: -- For bug fix 5231458