APPS.OKS_PM_PROGRAMS_PVT dependencies on OKS_PM_STREAM_LEVELS_V

Line 256: oks_pm_stream_levels_v

252: ACTIVITY_LINE_ID,
253: CLE_ID
254: DNZ_CHR_ID
255: FROM
256: oks_pm_stream_levels_v
257: WHERE cle_id = p_template_cle_id
258: AND ACTIVITY_LINE_ID is null
259: ORDER by SEQUENCE_NUMBER;
260: cr_prog_stream_levels cu_prog_stream_levels%ROWTYPE;

Line 278: oks_pm_stream_levels_v

274: ACTIVITY_LINE_ID,
275: CLE_ID
276: DNZ_CHR_ID
277: FROM
278: oks_pm_stream_levels_v
279: WHERE cle_id = p_template_cle_id
280: AND ACTIVITY_LINE_ID = cp_ACTIVITY_LINE_ID
281: ORDER by SEQUENCE_NUMBER;
282: cr_act_stream_levels cu_act_stream_levels%ROWTYPE;

Line 293: from oks_pm_stream_levels_V

289:
290: -- Added by jvorugan for Bug:5080930
291: cursor get_max_seq_no is
292: select max(to_number(SEQUENCE_NUMBER))
293: from oks_pm_stream_levels_V
294: where cle_id =p_template_cle_id
295: and ACTIVITY_LINE_ID is null;
296:
297: cursor get_max_act_seq_no(cp_activity_line_id IN NUMBER) is

Line 299: from oks_pm_stream_levels_V

295: and ACTIVITY_LINE_ID is null;
296:
297: cursor get_max_act_seq_no(cp_activity_line_id IN NUMBER) is
298: select max(to_number(SEQUENCE_NUMBER))
299: from oks_pm_stream_levels_V
300: where cle_id = p_template_cle_id
301: and ACTIVITY_LINE_ID = cp_ACTIVITY_LINE_ID;
302:
303: cursor check_renew(p_target_chr_id NUMBER)is

Line 1663: FROM OKS_PM_STREAM_LEVELS_V PML

1659: PROGRAM_ID ,
1660: ACTIVITY_LINE_ID,
1661: CLE_ID
1662: DNZ_CHR_ID
1663: FROM OKS_PM_STREAM_LEVELS_V PML
1664: WHERE CLE_ID=(select id from okc_k_lines_b where cle_id=p_contract_line_id
1665: and lse_id in (2,15,20));
1666:
1667: CR_STREAM_LEVELS CU_STREAM_LEVELS%ROWTYPE;*/

Line 1829: FROM OKS_PM_STREAM_LEVELS_V PML

1825: ACTIVITY_LINE_ID,
1826: CLE_ID,
1827: DNZ_CHR_ID,
1828: OBJECT_VERSION_NUMBER
1829: FROM OKS_PM_STREAM_LEVELS_V PML
1830: WHERE CLE_ID=p_contract_line_id
1831: -- and lse_id in (2,15,20)) commented by jvorugan as pm is associated with contract line
1832: AND ACTIVITY_LINE_ID IS NULL
1833: ORDER BY ACTIVITY_LINE_ID,SEQUENCE_NUMBER;

Line 1852: FROM OKS_PM_STREAM_LEVELS_V PML

1848: ACTIVITY_LINE_ID,
1849: CLE_ID,
1850: DNZ_CHR_ID,
1851: OBJECT_VERSION_NUMBER
1852: FROM OKS_PM_STREAM_LEVELS_V PML
1853: WHERE CLE_ID=p_contract_line_id
1854: -- and lse_id in (2,15,20)) commented by jvorugan as pm is associated with contract line
1855: AND ACTIVITY_LINE_ID = cp_activity_line_id
1856: ORDER BY ACTIVITY_LINE_ID,SEQUENCE_NUMBER;

Line 4050: FROM OKS_PM_STREAM_LEVELS_V PML

4046: AUTOSCHEDULE_YN,
4047: ACTIVITY_LINE_ID,
4048: CLE_ID
4049: DNZ_CHR_ID
4050: FROM OKS_PM_STREAM_LEVELS_V PML
4051: WHERE CLE_ID=cp_cov_line_id
4052: and activity_line_id is null
4053: ORDER BY SEQUENCE_NUMBER;
4054:

Line 4066: FROM OKS_PM_STREAM_LEVELS_V PML

4062: AUTOSCHEDULE_YN,
4063: ACTIVITY_LINE_ID,
4064: CLE_ID
4065: DNZ_CHR_ID
4066: FROM OKS_PM_STREAM_LEVELS_V PML
4067: WHERE activity_line_id =cp_activity_line_id
4068: ORDER BY SEQUENCE_NUMBER;
4069:
4070: