APPS.RCI_OPEN_REMED_SUMM_PKG dependencies on ENG_CHANGE_SUBJECTS

Line 886: rci_open_findings_f rof, eng_change_subjects ecs

882: CURSOR c_find IS
883: SELECT
884: DISTINCT finding_id
885: FROM
886: rci_open_findings_f rof, eng_change_subjects ecs
887: WHERE
888: rof.finding_id = ecs.change_id AND
889: (ecs.entity_name = 'PROJ_ORG' OR ecs.entity_name = 'PROJ_ORG_PROC');
890:

Line 891: CURSOR c_ch_sub(p_change_id eng_change_subjects.change_id%TYPE) IS

887: WHERE
888: rof.finding_id = ecs.change_id AND
889: (ecs.entity_name = 'PROJ_ORG' OR ecs.entity_name = 'PROJ_ORG_PROC');
890:
891: CURSOR c_ch_sub(p_change_id eng_change_subjects.change_id%TYPE) IS
892: SELECT
893: entity_name, pk1_value
894: FROM
895: eng_change_subjects ecs

Line 895: eng_change_subjects ecs

891: CURSOR c_ch_sub(p_change_id eng_change_subjects.change_id%TYPE) IS
892: SELECT
893: entity_name, pk1_value
894: FROM
895: eng_change_subjects ecs
896: WHERE change_id = p_change_id;
897:
898: v_finding_id rci_open_findings_f.finding_id%TYPE;
899: v_age rci_open_findings_f.age_in_days%TYPE;

Line 1118: rci_open_remediations_f rof, eng_change_subjects ecs

1114: CURSOR c_remed IS
1115: SELECT
1116: DISTINCT finding_id, age_in_days
1117: FROM
1118: rci_open_remediations_f rof, eng_change_subjects ecs
1119: WHERE
1120: rof.finding_id = ecs.change_id AND
1121: (ecs.entity_name = 'PROJ_ORG' OR ecs.entity_name = 'PROJ_ORG_PROC');
1122:

Line 1123: CURSOR c_ch_sub(p_change_id eng_change_subjects.change_id%TYPE) IS

1119: WHERE
1120: rof.finding_id = ecs.change_id AND
1121: (ecs.entity_name = 'PROJ_ORG' OR ecs.entity_name = 'PROJ_ORG_PROC');
1122:
1123: CURSOR c_ch_sub(p_change_id eng_change_subjects.change_id%TYPE) IS
1124: SELECT
1125: entity_name, pk1_value
1126: FROM
1127: eng_change_subjects ecs

Line 1127: eng_change_subjects ecs

1123: CURSOR c_ch_sub(p_change_id eng_change_subjects.change_id%TYPE) IS
1124: SELECT
1125: entity_name, pk1_value
1126: FROM
1127: eng_change_subjects ecs
1128: WHERE change_id = p_change_id;
1129: v_finding_id rci_open_remediations_f.finding_id%TYPE;
1130: v_age rci_open_remediations_f.age_in_days%TYPE;
1131: v_bucket_1 Number;