DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_I_ORG_ASSIGNMENTS

Line 1947: FROM csi_i_org_assignments

1943: SELECT instance_ou_id ,
1944: object_version_number
1945: INTO p_org_units_tbl(l_ind).instance_ou_id,
1946: p_org_units_tbl(l_ind).object_version_number
1947: FROM csi_i_org_assignments
1948: WHERE instance_id = p_instance_rec.instance_id
1949: AND relationship_type_code = p_org_units_tbl(l_ind).relationship_type_code
1950: AND operating_unit_id = p_org_units_tbl(l_ind).operating_unit_id
1951: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)

Line 2028: FROM csi_i_org_assignments

2024: SELECT instance_ou_id,
2025: operating_unit_id,
2026: relationship_type_code,
2027: object_version_number
2028: FROM csi_i_org_assignments
2029: WHERE instance_id = p_instance_rec.instance_id
2030: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
2031: AND nvl(active_end_date, sysdate+1);
2032: l_nou_ind binary_integer;