APPS.LNS_BILLING_BATCH_PUB dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 3238: from hr_all_organization_units_tl

3234:
3235: /* query for org name */
3236: CURSOR org_cur(P_ORG_ID number) IS
3237: select name
3238: from hr_all_organization_units_tl
3239: where ORGANIZATION_ID = P_ORG_ID and
3240: language(+) = userenv('LANG');
3241:
3242: /* query for loan product name */

Line 3562: 'hr_all_organization_units_tl org, ' ||

3558:
3559: 'FROM lns_loan_headers_all_vl loan, ' ||
3560: 'hz_parties party, ' ||
3561: 'fnd_territories_tl terr, ' ||
3562: 'hr_all_organization_units_tl org, ' ||
3563: 'LNS_PAY_SUM_V PAY_SUM, ' ||
3564: 'LNS_PAY_SUM_YEARLY_V PAY_SUM_YEARLY, ' ||
3565: 'LNS_PAY_SUM_OVERDUE_V PAY_SUM_OVERDUE, ' ||
3566: 'lns_amortization_scheds am, ' ||