APPS.PA_ADVERTISEMENTS_PUB dependencies on PA_ACTION_SET_LINE_COND

Line 267: pa_action_set_line_cond aslc

263: -- Escalate to next level order by line number
264: SELECT aslc.condition_code, aslc.condition_attribute1, aslc.condition_attribute2
265: BULK COLLECT INTO l_condition_code_tbl, l_condition_attribute1_tbl, l_condition_attribute2_tbl
266: FROM pa_action_set_lines asl,
267: pa_action_set_line_cond aslc
268: WHERE asl.action_set_id = p_action_set_id
269: AND asl.action_set_line_id = aslc.action_set_line_id
270: AND (asl.action_code = 'ADVERTISEMENT_ESC_TO_NEXT_LVL'
271: OR asl.action_code = 'ADVERTISEMENT_PUB_TO_START_ORG')

Line 696: pa_action_set_line_cond aslc

692: -- get all completed action lines whose conditions are no longer met
693: SELECT asl.action_set_line_id, 'UPDATE_PENDING', aslc.condition_date, aslc.action_set_line_condition_id
694: BULK COLLECT INTO l_action_set_line_id_tbl, l_action_status_code_tbl, l_condition_date_tbl, l_action_line_cond_id_tbl
695: FROM pa_action_set_lines asl,
696: pa_action_set_line_cond aslc
697: WHERE asl.action_set_id = l_action_set_id
698: AND asl.status_code = 'COMPLETE'
699: AND asl.action_set_line_id = aslc.action_set_line_id
700: AND aslc.condition_date > SYSDATE;

Line 736: pa_action_set_line_cond aslc

732: -- These lines will be in REVERSED status with deleted_flag <> 'Y'
733: SELECT asl.action_set_line_id, 'PENDING', aslc.condition_date, aslc.action_set_line_condition_id
734: BULK COLLECT INTO l_action_set_line_id_tbl, l_action_status_code_tbl, l_condition_date_tbl, l_action_line_cond_id_tbl
735: FROM pa_action_set_lines asl,
736: pa_action_set_line_cond aslc
737: WHERE asl.action_set_id = l_action_set_id
738: AND asl.status_code = 'REVERSED'
739: AND nvl(asl.line_deleted_flag, 'N') = 'N'
740: AND asl.action_set_line_id = aslc.action_set_line_id