APPS.AP_APXTRSWP_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 521: HR_ALL_ORGANIZATION_UNITS_TL LE,

517:
518: c_select_le := 'le.name ';
519: c_select_ou := 'ou.name ';
520: c_org_from_tables := 'HR_ORGANIZATION_INFORMATION OI,
521: HR_ALL_ORGANIZATION_UNITS_TL LE,
522: HR_ALL_ORGANIZATION_UNITS_TL OU' ;
523:
524: ELSE
525: c_inv_multi_org_where := 'AND 1=1';

Line 522: HR_ALL_ORGANIZATION_UNITS_TL OU' ;

518: c_select_le := 'le.name ';
519: c_select_ou := 'ou.name ';
520: c_org_from_tables := 'HR_ORGANIZATION_INFORMATION OI,
521: HR_ALL_ORGANIZATION_UNITS_TL LE,
522: HR_ALL_ORGANIZATION_UNITS_TL OU' ;
523:
524: ELSE
525: c_inv_multi_org_where := 'AND 1=1';
526: c_aip_multi_org_where := 'AND 1 = 1';

Line 559: HR_ALL_ORGANIZATION_UNITS_TL LE,

555: AND NVL(AID.ORG_ID,-99) = NVL(PD.ORG_ID,-99)
556: AND NVL(AID.ORG_ID,-99) IN
557: (SELECT NVL(ASP.ORG_ID,-99)
558: FROM HR_ORGANIZATION_INFORMATION OI,
559: HR_ALL_ORGANIZATION_UNITS_TL LE,
560: HR_ALL_ORGANIZATION_UNITS_TL OU,
561: AP_SYSTEM_PARAMETERS_ALL ASP,
562: GL_SETS_OF_BOOKS SOB
563: WHERE nvl(SOB.SLA_LEDGER_CASH_BASIS_FLAG, 'N') <> 'Y'

Line 560: HR_ALL_ORGANIZATION_UNITS_TL OU,

556: AND NVL(AID.ORG_ID,-99) IN
557: (SELECT NVL(ASP.ORG_ID,-99)
558: FROM HR_ORGANIZATION_INFORMATION OI,
559: HR_ALL_ORGANIZATION_UNITS_TL LE,
560: HR_ALL_ORGANIZATION_UNITS_TL OU,
561: AP_SYSTEM_PARAMETERS_ALL ASP,
562: GL_SETS_OF_BOOKS SOB
563: WHERE nvl(SOB.SLA_LEDGER_CASH_BASIS_FLAG, 'N') <> 'Y'
564: AND SOB.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID

Line 646: hr_all_organization_units_tl le,

642: OR (p_period_name is not null and aid.period_name = p_period_name))
643: AND nvl(aid.org_id, -99) IN
644: (select nvl(asp.org_id, -99)
645: from hr_organization_information oi,
646: hr_all_organization_units_tl le,
647: hr_all_organization_units_tl ou,
648: ap_system_parameters_all asp
649: where asp.accounting_method_option = 'Accrual'
650: and asp.org_id = oi.organization_id

Line 647: hr_all_organization_units_tl ou,

643: AND nvl(aid.org_id, -99) IN
644: (select nvl(asp.org_id, -99)
645: from hr_organization_information oi,
646: hr_all_organization_units_tl le,
647: hr_all_organization_units_tl ou,
648: ap_system_parameters_all asp
649: where asp.accounting_method_option = 'Accrual'
650: and asp.org_id = oi.organization_id
651: and ou.organization_id = oi.organization_id

Line 741: hr_all_organization_units_tl le,

737: OR (p_period_name is not null and period_name = p_period_name))
738: AND nvl(aip.org_id, -99) IN
739: (select nvl(asp.org_id, -99)
740: from hr_organization_information oi,
741: hr_all_organization_units_tl le,
742: hr_all_organization_units_tl ou,
743: ap_system_parameters_all asp
744:
745: where

Line 742: hr_all_organization_units_tl ou,

738: AND nvl(aip.org_id, -99) IN
739: (select nvl(asp.org_id, -99)
740: from hr_organization_information oi,
741: hr_all_organization_units_tl le,
742: hr_all_organization_units_tl ou,
743: ap_system_parameters_all asp
744:
745: where
746: asp.org_id = oi.organization_id

Line 780: hr_all_organization_units_tl le,

776: and c_to_acctg_date))
777: AND nvl(aph.org_id, -99) IN
778: (select nvl(asp.org_id, -99)
779: from hr_organization_information oi,
780: hr_all_organization_units_tl le,
781: hr_all_organization_units_tl ou,
782: ap_system_parameters_all asp
783: where
784: asp.org_id = oi.organization_id

Line 781: hr_all_organization_units_tl ou,

777: AND nvl(aph.org_id, -99) IN
778: (select nvl(asp.org_id, -99)
779: from hr_organization_information oi,
780: hr_all_organization_units_tl le,
781: hr_all_organization_units_tl ou,
782: ap_system_parameters_all asp
783: where
784: asp.org_id = oi.organization_id
785: and ou.organization_id = oi.organization_id