DBA Data[Home] [Help]

APPS.HR_MX_UTILITY dependencies on HR_ORGANIZATION_UNITS

Line 370: r_legal_employer_id hr_organization_units.organization_id%TYPE;

366: --------------------------------------------------------------------------
367: FUNCTION get_legal_employer(p_business_group_id NUMBER,
368: p_tax_unit_id NUMBER) RETURN NUMBER IS
369: --
370: r_legal_employer_id hr_organization_units.organization_id%TYPE;
371: lv_proc VARCHAR2(240);
372: ld_effective_date DATE;
373: BEGIN
374:

Line 428: r_legal_employer_id hr_organization_units.organization_id%TYPE;

424: p_tax_unit_id NUMBER,
425: p_effective_date DATE)
426: RETURN NUMBER IS
427: --
428: r_legal_employer_id hr_organization_units.organization_id%TYPE;
429: lv_proc VARCHAR2(240);
430: BEGIN
431:
432: lv_proc := 'hr_mx_utility.get_legal_employer-2';

Line 510: lv_org_name hr_organization_units.name%TYPE;

506:
507: FUNCTION get_organization_name (p_organization_id NUMBER)
508: RETURN VARCHAR2 IS
509:
510: lv_org_name hr_organization_units.name%TYPE;
511:
512: BEGIN
513:
514: lv_proc := 'get_organization_name';

Line 606: lv_gre_name hr_organization_units.name%TYPE;

602: FUNCTION get_wrip(p_business_group_id NUMBER, p_tax_unit_id NUMBER)
603: RETURN NUMBER IS
604:
605: r_wrip NUMBER;
606: lv_gre_name hr_organization_units.name%TYPE;
607: lv_proc VARCHAR2(240);
608:
609: BEGIN
610:

Line 677: lv_gre_name hr_organization_units.name%TYPE;

673: p_tax_unit_id NUMBER)
674: RETURN NUMBER IS
675:
676: r_tax_subsidy_percentage NUMBER;
677: lv_gre_name hr_organization_units.name%TYPE;
678: lv_le_name hr_organization_units.name%TYPE;
679: ln_legal_employer_id hr_organization_units.organization_id%TYPE;
680: lv_proc VARCHAR2(240);
681:

Line 678: lv_le_name hr_organization_units.name%TYPE;

674: RETURN NUMBER IS
675:
676: r_tax_subsidy_percentage NUMBER;
677: lv_gre_name hr_organization_units.name%TYPE;
678: lv_le_name hr_organization_units.name%TYPE;
679: ln_legal_employer_id hr_organization_units.organization_id%TYPE;
680: lv_proc VARCHAR2(240);
681:
682: BEGIN

Line 679: ln_legal_employer_id hr_organization_units.organization_id%TYPE;

675:
676: r_tax_subsidy_percentage NUMBER;
677: lv_gre_name hr_organization_units.name%TYPE;
678: lv_le_name hr_organization_units.name%TYPE;
679: ln_legal_employer_id hr_organization_units.organization_id%TYPE;
680: lv_proc VARCHAR2(240);
681:
682: BEGIN
683:

Line 777: lv_gre_name hr_organization_units.name%TYPE;

773: p_effective_date DATE)
774: RETURN NUMBER IS
775:
776: r_tax_subsidy_percentage NUMBER;
777: lv_gre_name hr_organization_units.name%TYPE;
778: lv_le_name hr_organization_units.name%TYPE;
779: ln_legal_employer_id hr_organization_units.organization_id%TYPE;
780: lv_proc VARCHAR2(240);
781:

Line 778: lv_le_name hr_organization_units.name%TYPE;

774: RETURN NUMBER IS
775:
776: r_tax_subsidy_percentage NUMBER;
777: lv_gre_name hr_organization_units.name%TYPE;
778: lv_le_name hr_organization_units.name%TYPE;
779: ln_legal_employer_id hr_organization_units.organization_id%TYPE;
780: lv_proc VARCHAR2(240);
781:
782: BEGIN

Line 779: ln_legal_employer_id hr_organization_units.organization_id%TYPE;

775:
776: r_tax_subsidy_percentage NUMBER;
777: lv_gre_name hr_organization_units.name%TYPE;
778: lv_le_name hr_organization_units.name%TYPE;
779: ln_legal_employer_id hr_organization_units.organization_id%TYPE;
780: lv_proc VARCHAR2(240);
781:
782: BEGIN
783: