DBA Data[Home] [Help]

APPS.AS_SC_DENORM dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 461: hr_all_organization_units_tl org,

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

Line 633: hr_all_organization_units_tl org,

629: aso_i_sales_credit_types_v ctypes,
630: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
631: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
632: jtf_rs_resource_extns jrs2,
633: hr_all_organization_units_tl org,
634: as_period_rates pr, as_period_days pd
635: Where
636: ll.lead_id = lead.lead_id
637: and ll.lead_line_id = sc.lead_line_id

Line 768: hr_all_organization_units_tl org

764: mtl_units_of_measure_tl mtluom,
765: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
766: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
767: jtf_rs_resource_extns jrs2,
768: hr_all_organization_units_tl org
769: WHERE scdh.sales_stage_id = sales.sales_stage_id(+)
770: And sales.language(+) = userenv('LANG')
771: And scdh.status_code = status.status_code
772: And status.language = userenv('LANG')