APPS.CSTPDPPC dependencies on CST_PAC_PROCESS_PHASES

Line 25: cst_pac_process_phases

21: )
22: IS
23: BEGIN
24: UPDATE
25: cst_pac_process_phases
26: SET
27: process_status = i_status,
28: process_date = SYSDATE,
29: process_upto_date = (select decode(i_status,4,process_upto_date,NULL)

Line 30: from cst_pac_process_phases

26: SET
27: process_status = i_status,
28: process_date = SYSDATE,
29: process_upto_date = (select decode(i_status,4,process_upto_date,NULL)
30: from cst_pac_process_phases
31: where process_phase = 5
32: and cost_group_id = i_cost_group_id
33: and pac_period_id = i_period_id),
34: last_update_date = SYSDATE,

Line 383: cst_pac_process_phases

379: pac_period_id IN
380: (SELECT
381: DISTINCT pac_period_id
382: FROM
383: cst_pac_process_phases
384: WHERE
385: cost_group_id = i_cost_group_id AND
386: process_phase = 5 AND
387: process_status = 4);

Line 398: cst_pac_process_phases

394: count(*)
395: INTO
396: l_running_period
397: FROM
398: cst_pac_process_phases
399: WHERE
400: pac_period_id = i_period_id AND
401: cost_group_id = i_cost_group_id AND
402: process_phase = 6 AND

Line 434: cst_pac_process_phases

430: pac_period_id IN
431: (SELECT
432: DISTINCT pac_period_id
433: FROM
434: cst_pac_process_phases
435: WHERE
436: cost_group_id = i_cost_group_id AND
437: process_phase = 6 AND
438: process_status = 4);