APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_CF_RECOMMENDS

Line 400: insert into ar_cmgt_cf_recommends

396: THEN
397: l_recommendation_name := 'AR_CMGT_RECOMMENDATIONS';
398: END IF;
399: END IF;
400: insert into ar_cmgt_cf_recommends
401: ( Recommendation_id,
402: case_folder_id,
403: credit_request_id,
404: credit_review_date,

Line 417: ( ar_cmgt_cf_recommends_s.nextval,

413: created_by,
414: credit_type,
415: recommendation_name,
416: application_id) values
417: ( ar_cmgt_cf_recommends_s.nextval,
418: p_case_folder_id,
419: p_credit_request_id,
420: p_credit_review_date,
421: p_credit_recommendation,

Line 1618: INSERT INTO AR_CMGT_CF_RECOMMENDS

1614:
1615: IF l_processing_flag = 'Y'
1616: THEN
1617: BEGIN
1618: INSERT INTO AR_CMGT_CF_RECOMMENDS
1619: (RECOMMENDATION_ID,
1620: LAST_UPDATED_BY,
1621: LAST_UPDATE_DATE,
1622: LAST_UPDATE_LOGIN,

Line 1635: (SELECT AR_CMGT_CF_RECOMMENDS_S.NEXTVAL,

1631: STATUS,
1632: CREDIT_TYPE,
1633: RECOMMENDATION_NAME,
1634: APPLICATION_ID)
1635: (SELECT AR_CMGT_CF_RECOMMENDS_S.NEXTVAL,
1636: fnd_global.user_id,
1637: SYSDATE,
1638: fnd_global.login_id,
1639: SYSDATE,

Line 1651: FROM AR_CMGT_CF_RECOMMENDS

1647: STATUS,
1648: CREDIT_TYPE,
1649: RECOMMENDATION_NAME,
1650: APPLICATION_ID
1651: FROM AR_CMGT_CF_RECOMMENDS
1652: WHERE CASE_FOLDER_ID= p_parnt_case_folder_id);
1653: EXCEPTION
1654: WHEN OTHERS
1655: THEN