APPS.JMF_GTA_REPORTS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 786: l_org_id hr_all_organization_units.organization_id%TYPE

782: IS
783: l_ar_header_id NUMBER
784: :=p_ar_header_id;
785:
786: l_org_id hr_all_organization_units.organization_id%TYPE
787: :=p_org_id;
788:
789: l_ar_amount NUMBER;
790: l_ar_amount_disp VARCHAR2(50);

Line 2011: l_org_id hr_all_organization_units.organization_id%TYPE

2007: , x_ar_partially_import OUT NOCOPY NUMBER
2008: , x_has_difference OUT NOCOPY BOOLEAN
2009: )
2010: IS
2011: l_org_id hr_all_organization_units.organization_id%TYPE
2012: :=p_org_id;
2013: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
2014: :=p_ar_header_id;
2015: l_has_difference BOOLEAN;

Line 3360: l_org_id hr_all_organization_units.organization_id%TYPE

3356: , x_has_difference OUT NOCOPY BOOLEAN
3357: )
3358: IS
3359:
3360: l_org_id hr_all_organization_units.organization_id%TYPE
3361: :=p_org_id;
3362: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
3363: :=p_ar_header_id;
3364: l_has_difference BOOLEAN;

Line 3733: hr_all_organization_units o

3729: CURSOR c_operating_unit IS
3730: SELECT
3731: otl.name
3732: FROM
3733: hr_all_organization_units o
3734: ,hr_all_organization_units_tl otl
3735: WHERE o.organization_id = otl.organization_id
3736: AND otl.language = userenv('LANG')
3737: AND o.organization_id = p_org_id;

Line 3734: ,hr_all_organization_units_tl otl

3730: SELECT
3731: otl.name
3732: FROM
3733: hr_all_organization_units o
3734: ,hr_all_organization_units_tl otl
3735: WHERE o.organization_id = otl.organization_id
3736: AND otl.language = userenv('LANG')
3737: AND o.organization_id = p_org_id;
3738: