DBA Data[Home] [Help]

APPS.WIP_JSI_VALIDATOR dependencies on WIP_PARAMETERS

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

556: -- sugupta 26th-May-2006
557: /*
558: select ood.disable_date
559: into l_disable_date
560: from wip_parameters wp, mtl_parameters mp, org_organization_definitions ood
561: where wp.organization_id = mp.organization_id
562: and wp.organization_id = ood.organization_id
563: and wp.organization_id = wjsi_row.organization_id;
564: */

Line 567: FROM wip_parameters wp,

563: and wp.organization_id = wjsi_row.organization_id;
564: */
565: SELECT ood.date_to disable_date
566: INTO l_disable_date
567: FROM wip_parameters wp,
568: mtl_parameters mp ,
569: hr_organization_units ood
570: WHERE wp.organization_id = mp.organization_id
571: and wp.organization_id = ood.organization_id

Line 962: FROM wip_parameters wp

958: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
959:
960: SELECT propagate_job_change_to_po
961: INTO l_propagate_job_change_to_po
962: FROM wip_parameters wp
963: WHERE organization_id = wjsi_row.organization_id;
964:
965: IF(l_propagate_job_change_to_po = WIP_CONSTANTS.YES AND
966: wjsi_row.status_type IN (WIP_CONSTANTS.CANCELLED,