APPS.AR_GTA_REPORTS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 852: l_org_id hr_all_organization_units.organization_id%TYPE

848: IS
849: l_ar_header_id NUMBER
850: :=p_ar_header_id;
851:
852: l_org_id hr_all_organization_units.organization_id%TYPE
853: :=p_org_id;
854:
855: l_ar_amount NUMBER;
856: l_ar_amount_disp VARCHAR2(50);

Line 2114: l_org_id hr_all_organization_units.organization_id%TYPE

2110: , x_ar_partially_import OUT NOCOPY NUMBER
2111: , x_has_difference OUT NOCOPY BOOLEAN
2112: )
2113: IS
2114: l_org_id hr_all_organization_units.organization_id%TYPE
2115: :=p_org_id;
2116: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
2117: :=p_ar_header_id;
2118: l_has_difference BOOLEAN;

Line 3536: l_org_id hr_all_organization_units.organization_id%TYPE

3532: , x_has_difference OUT NOCOPY BOOLEAN
3533: )
3534: IS
3535:
3536: l_org_id hr_all_organization_units.organization_id%TYPE
3537: :=p_org_id;
3538: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
3539: :=p_ar_header_id;
3540: l_has_difference BOOLEAN;

Line 3916: hr_all_organization_units o

3912: CURSOR c_operating_unit IS
3913: SELECT
3914: otl.name
3915: FROM
3916: hr_all_organization_units o
3917: ,hr_all_organization_units_tl otl
3918: WHERE o.organization_id = otl.organization_id
3919: AND otl.language = userenv('LANG')
3920: AND o.organization_id = p_org_id;

Line 3917: ,hr_all_organization_units_tl otl

3913: SELECT
3914: otl.name
3915: FROM
3916: hr_all_organization_units o
3917: ,hr_all_organization_units_tl otl
3918: WHERE o.organization_id = otl.organization_id
3919: AND otl.language = userenv('LANG')
3920: AND o.organization_id = p_org_id;
3921: