DBA Data[Home] [Help]

APPS.WIP_JSI_VALIDATOR dependencies on WIP_PARAMETERS

Line 555: from wip_parameters wp, mtl_parameters mp, org_organization_definitions ood

551: -- sugupta 26th-May-2006
552: /*
553: select ood.disable_date
554: into l_disable_date
555: from wip_parameters wp, mtl_parameters mp, org_organization_definitions ood
556: where wp.organization_id = mp.organization_id
557: and wp.organization_id = ood.organization_id
558: and wp.organization_id = wjsi_row.organization_id;
559: */

Line 562: FROM wip_parameters wp,

558: and wp.organization_id = wjsi_row.organization_id;
559: */
560: SELECT ood.date_to disable_date
561: INTO l_disable_date
562: FROM wip_parameters wp,
563: mtl_parameters mp ,
564: hr_organization_units ood
565: WHERE wp.organization_id = mp.organization_id
566: and wp.organization_id = ood.organization_id

Line 957: FROM wip_parameters wp

953: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
954:
955: SELECT propagate_job_change_to_po
956: INTO l_propagate_job_change_to_po
957: FROM wip_parameters wp
958: WHERE organization_id = wjsi_row.organization_id;
959:
960: IF(l_propagate_job_change_to_po = WIP_CONSTANTS.YES AND
961: wjsi_row.status_type IN (WIP_CONSTANTS.CANCELLED,