DBA Data[Home] [Help]

APPS.AS_SC_DENORM dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 463: hr_all_organization_units_tl org,

459: aso_i_sales_credit_types_v ctypes,
460: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
461: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
462: jtf_rs_resource_extns jrs2,
463: hr_all_organization_units_tl org,
464: as_period_rates pr, as_period_days pd
465: Where
466: ll.lead_id = lead.lead_id
467: and ll.lead_line_id = sc.lead_line_id

Line 604: hr_all_organization_units_tl org

600: mtl_units_of_measure_tl mtluom,
601: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
602: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
603: jtf_rs_resource_extns jrs2,
604: hr_all_organization_units_tl org
605: WHERE scdh.sales_stage_id = sales.sales_stage_id(+)
606: And sales.language(+) = userenv('LANG')
607: And scdh.status_code = status.status_code
608: And status.language = userenv('LANG')