DBA Data[Home] [Help]

APPS.JA_JAINITCP_XMLP_PKG dependencies on HR_LOCATIONS

Line 49: HR_LOCATIONS LOC,

45: FROM
46: JAI_AP_TDS_F16_HDRS_ALL AFRM,
47: JAI_AP_TDS_F16_DTLS_ALL FRMD,
48: HR_ORGANIZATION_UNITS HOU,
49: HR_LOCATIONS LOC,
50: JAI_CMN_INVENTORY_ORGS JHOU,
51: AP_INVOICES_ALL API1,
52: AP_INVOICES_ALL API2,
53: AP_INVOICE_PAYMENTS_ALL APIP,

Line 131: HR_LOCATIONS LOC,

127: NVL(LOC.TOWN_OR_CITY
128: ,'NIL') || '-' || NVL(LOC.POSTAL_CODE
129: ,'NIL')
130: FROM
131: HR_LOCATIONS LOC,
132: HR_ORGANIZATION_UNITS HR
133: WHERE LOC.LOCATION_ID = HR.LOCATION_ID
134: AND HR.ORGANIZATION_ID = CP_ORGANIZATION_ID;
135: CURSOR COUNTRY_CUR(CP_ORGANIZATION_ID IN NUMBER) IS

Line 140: HR_LOCATIONS LOC,

136: SELECT
137: NVL(LOC.COUNTRY
138: ,'NIL')
139: FROM
140: HR_LOCATIONS LOC,
141: HR_ORGANIZATION_UNITS HR
142: WHERE LOC.LOCATION_ID = HR.LOCATION_ID
143: AND HR.ORGANIZATION_ID = CP_ORGANIZATION_ID;
144: CURSOR PO_VENDOR_NAME_CUR(P_TDS_PAYMENT_TYPE IN VARCHAR2) IS