APPS.AP_APXTRSWP_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 520: c_org_from_tables := 'HR_ORGANIZATION_INFORMATION OI,

516:
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

Line 558: FROM HR_ORGANIZATION_INFORMATION OI,

554: AND AID.POSTED_FLAG = 'N'
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

Line 645: from hr_organization_information oi,

641: and p_to_acctg_date)
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'

Line 740: from hr_organization_information oi,

736: and p_to_acctg_date)
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:

Line 779: from hr_organization_information oi,

775: (p_period_name is not null and accounting_date between c_from_acctg_date
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