APPS.IGS_RE_WORKFLOW dependencies on IGS_PR_MILESTONE

Line 2309: p_seq_num igs_pr_milestone.ca_sequence_number%TYPE

2305: -- For each person program attempt identified above select the milestone records, which do not have the
2306: -- status of 'ACHIEVED' and the due date is less than SYSDATE.
2307:
2308: CURSOR cur_achived_milestone ( p_person_id igs_pe_person_base_v.person_id%TYPE,
2309: p_seq_num igs_pr_milestone.ca_sequence_number%TYPE
2310: )IS
2311: SELECT a.due_dt, NVL(ovrd_ntfctn_imminent_days, b.NTFCTN_IMMINENT_DAYS) ovrd_ntfctn_imminent_days,
2312: nvl(ovrd_ntfctn_reminder_days, b.NTFCTN_REMINDER_DAYS) ovrd_ntfctn_reminder_days,
2313: nvl(ovrd_ntfctn_re_reminder_days, b.NTFCTN_RE_REMINDER_DAYS) ovrd_ntfctn_re_reminder_days, a.milestone_status, a.milestone_type

Line 2314: FROM igs_pr_milestone a,

2310: )IS
2311: SELECT a.due_dt, NVL(ovrd_ntfctn_imminent_days, b.NTFCTN_IMMINENT_DAYS) ovrd_ntfctn_imminent_days,
2312: nvl(ovrd_ntfctn_reminder_days, b.NTFCTN_REMINDER_DAYS) ovrd_ntfctn_reminder_days,
2313: nvl(ovrd_ntfctn_re_reminder_days, b.NTFCTN_RE_REMINDER_DAYS) ovrd_ntfctn_re_reminder_days, a.milestone_status, a.milestone_type
2314: FROM igs_pr_milestone a,
2315: igs_pr_milestone_typ b
2316: WHERE a.person_id = p_person_id
2317: AND a.ca_sequence_number = p_seq_num
2318: AND a.milestone_status <> 'ACHIEVED'

Line 2315: igs_pr_milestone_typ b

2311: SELECT a.due_dt, NVL(ovrd_ntfctn_imminent_days, b.NTFCTN_IMMINENT_DAYS) ovrd_ntfctn_imminent_days,
2312: nvl(ovrd_ntfctn_reminder_days, b.NTFCTN_REMINDER_DAYS) ovrd_ntfctn_reminder_days,
2313: nvl(ovrd_ntfctn_re_reminder_days, b.NTFCTN_RE_REMINDER_DAYS) ovrd_ntfctn_re_reminder_days, a.milestone_status, a.milestone_type
2314: FROM igs_pr_milestone a,
2315: igs_pr_milestone_typ b
2316: WHERE a.person_id = p_person_id
2317: AND a.ca_sequence_number = p_seq_num
2318: AND a.milestone_status <> 'ACHIEVED'
2319: AND TRUNC(a.due_dt) >= TRUNC(SYSDATE)