APPS.OKL_LEASE_APP_PVT dependencies on AR_CMGT_CREDIT_REQUESTS

Line 17: application_number AR_CMGT_CREDIT_REQUESTS.APPLICATION_NUMBER%TYPE,

13: -- Record type for the credit Application
14: TYPE crr_rec_type IS RECORD(
15: l_commit VARCHAR2(15),
16: validation_level VARCHAR2(50),
17: application_number AR_CMGT_CREDIT_REQUESTS.APPLICATION_NUMBER%TYPE,
18: application_date AR_CMGT_CREDIT_REQUESTS.APPLICATION_DATE%TYPE,
19: requestor_type AR_CMGT_CREDIT_REQUESTS.REQUESTOR_TYPE%TYPE,
20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,
21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,

Line 18: application_date AR_CMGT_CREDIT_REQUESTS.APPLICATION_DATE%TYPE,

14: TYPE crr_rec_type IS RECORD(
15: l_commit VARCHAR2(15),
16: validation_level VARCHAR2(50),
17: application_number AR_CMGT_CREDIT_REQUESTS.APPLICATION_NUMBER%TYPE,
18: application_date AR_CMGT_CREDIT_REQUESTS.APPLICATION_DATE%TYPE,
19: requestor_type AR_CMGT_CREDIT_REQUESTS.REQUESTOR_TYPE%TYPE,
20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,
21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,
22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,

Line 19: requestor_type AR_CMGT_CREDIT_REQUESTS.REQUESTOR_TYPE%TYPE,

15: l_commit VARCHAR2(15),
16: validation_level VARCHAR2(50),
17: application_number AR_CMGT_CREDIT_REQUESTS.APPLICATION_NUMBER%TYPE,
18: application_date AR_CMGT_CREDIT_REQUESTS.APPLICATION_DATE%TYPE,
19: requestor_type AR_CMGT_CREDIT_REQUESTS.REQUESTOR_TYPE%TYPE,
20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,
21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,
22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,
23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,

Line 20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,

16: validation_level VARCHAR2(50),
17: application_number AR_CMGT_CREDIT_REQUESTS.APPLICATION_NUMBER%TYPE,
18: application_date AR_CMGT_CREDIT_REQUESTS.APPLICATION_DATE%TYPE,
19: requestor_type AR_CMGT_CREDIT_REQUESTS.REQUESTOR_TYPE%TYPE,
20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,
21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,
22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,
23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,
24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,

Line 21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,

17: application_number AR_CMGT_CREDIT_REQUESTS.APPLICATION_NUMBER%TYPE,
18: application_date AR_CMGT_CREDIT_REQUESTS.APPLICATION_DATE%TYPE,
19: requestor_type AR_CMGT_CREDIT_REQUESTS.REQUESTOR_TYPE%TYPE,
20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,
21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,
22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,
23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,
24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,
25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,

Line 22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,

18: application_date AR_CMGT_CREDIT_REQUESTS.APPLICATION_DATE%TYPE,
19: requestor_type AR_CMGT_CREDIT_REQUESTS.REQUESTOR_TYPE%TYPE,
20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,
21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,
22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,
23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,
24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,
25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,
26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,

Line 23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,

19: requestor_type AR_CMGT_CREDIT_REQUESTS.REQUESTOR_TYPE%TYPE,
20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,
21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,
22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,
23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,
24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,
25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,
26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,
27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,

Line 24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,

20: requestor_id AR_CMGT_CREDIT_REQUESTS.REQUESTOR_ID%TYPE,
21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,
22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,
23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,
24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,
25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,
26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,
27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,
28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,

Line 25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,

21: review_type AR_CMGT_CREDIT_REQUESTS.REVIEW_TYPE%TYPE,
22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,
23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,
24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,
25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,
26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,
27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,
28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,
29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,

Line 26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,

22: credit_classification AR_CMGT_CREDIT_REQUESTS.CREDIT_CLASSIFICATION%TYPE,
23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,
24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,
25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,
26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,
27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,
28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,
29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,
30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,

Line 27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,

23: requested_amount AR_CMGT_CREDIT_REQUESTS.LIMIT_AMOUNT%TYPE,
24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,
25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,
26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,
27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,
28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,
29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,
30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,
31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,

Line 28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,

24: requested_currency AR_CMGT_CREDIT_REQUESTS.LIMIT_CURRENCY%TYPE,
25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,
26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,
27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,
28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,
29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,
30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,
31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,
32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,

Line 29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,

25: trx_amount AR_CMGT_CREDIT_REQUESTS.TRX_AMOUNT%TYPE,
26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,
27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,
28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,
29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,
30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,
31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,
32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,
33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,

Line 30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,

26: trx_currency AR_CMGT_CREDIT_REQUESTS.TRX_CURRENCY%TYPE,
27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,
28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,
29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,
30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,
31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,
32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,
33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,
34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,

Line 31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,

27: credit_type AR_CMGT_CREDIT_REQUESTS.CREDIT_TYPE%TYPE,
28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,
29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,
30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,
31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,
32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,
33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,
34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,
35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,

Line 32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,

28: term_length AR_CMGT_CREDIT_REQUESTS.TERM_LENGTH%TYPE,
29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,
30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,
31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,
32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,
33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,
34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,
35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,
36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,

Line 33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,

29: credit_check_rule_id AR_CMGT_CREDIT_REQUESTS.CREDIT_CHECK_RULE_ID%TYPE,
30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,
31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,
32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,
33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,
34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,
35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,
36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,
37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,

Line 34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,

30: credit_request_status AR_CMGT_CREDIT_REQUESTS.STATUS%TYPE,
31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,
32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,
33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,
34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,
35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,
36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,
37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,
38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,

Line 35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,

31: party_id AR_CMGT_CREDIT_REQUESTS.PARTY_ID%TYPE,
32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,
33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,
34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,
35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,
36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,
37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,
38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,
39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,

Line 36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,

32: cust_account_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCOUNT_ID%TYPE,
33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,
34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,
35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,
36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,
37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,
38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,
39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,
40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,

Line 37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,

33: cust_acct_site_id AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID%TYPE,
34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,
35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,
36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,
37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,
38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,
39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,
40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,
41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,

Line 38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,

34: site_use_id AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID%TYPE,
35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,
36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,
37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,
38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,
39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,
40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,
41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,
42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,

Line 39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,

35: contact_party_id AR_CMGT_CREDIT_REQUESTS.CONTACT_PARTY_ID%TYPE,
36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,
37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,
38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,
39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,
40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,
41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,
42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,
43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,

Line 40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,

36: notes AR_CMGT_CREDIT_REQUESTS.NOTES%TYPE,
37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,
38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,
39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,
40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,
41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,
42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,
43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,
44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,

Line 41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,

37: source_org_id AR_CMGT_CREDIT_REQUESTS.SOURCE_ORG_ID%TYPE,
38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,
39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,
40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,
41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,
42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,
43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,
44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,
45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,

Line 42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,

38: source_user_id AR_CMGT_CREDIT_REQUESTS.SOURCE_USER_ID%TYPE,
39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,
40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,
41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,
42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,
43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,
44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,
45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,
46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,

Line 43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,

39: source_resp_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_ID%TYPE,
40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,
41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,
42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,
43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,
44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,
45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,
46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,
47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,

Line 44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,

40: source_appln_id AR_CMGT_CREDIT_REQUESTS.SOURCE_RESP_APPLN_ID%TYPE,
41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,
42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,
43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,
44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,
45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,
46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,
47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,
48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,

Line 45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,

41: source_security_group_id AR_CMGT_CREDIT_REQUESTS.SOURCE_SECURITY_GROUP_ID%TYPE,
42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,
43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,
44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,
45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,
46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,
47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,
48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,
49: score_model_id AR_CMGT_CREDIT_REQUESTS.SCORE_MODEL_ID%TYPE,

Line 46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,

42: source_name AR_CMGT_CREDIT_REQUESTS.SOURCE_NAME%TYPE,
43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,
44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,
45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,
46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,
47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,
48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,
49: score_model_id AR_CMGT_CREDIT_REQUESTS.SCORE_MODEL_ID%TYPE,
50: parent_credit_request_id AR_CMGT_CREDIT_REQUESTS.PARENT_CREDIT_REQUEST_ID%TYPE,

Line 47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,

43: source_column1 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN1%TYPE,
44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,
45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,
46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,
47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,
48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,
49: score_model_id AR_CMGT_CREDIT_REQUESTS.SCORE_MODEL_ID%TYPE,
50: parent_credit_request_id AR_CMGT_CREDIT_REQUESTS.PARENT_CREDIT_REQUEST_ID%TYPE,
51: credit_request_type AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_TYPE%TYPE

Line 48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,

44: source_column2 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN2%TYPE,
45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,
46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,
47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,
48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,
49: score_model_id AR_CMGT_CREDIT_REQUESTS.SCORE_MODEL_ID%TYPE,
50: parent_credit_request_id AR_CMGT_CREDIT_REQUESTS.PARENT_CREDIT_REQUEST_ID%TYPE,
51: credit_request_type AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_TYPE%TYPE
52: );

Line 49: score_model_id AR_CMGT_CREDIT_REQUESTS.SCORE_MODEL_ID%TYPE,

45: source_column3 AR_CMGT_CREDIT_REQUESTS.SOURCE_COLUMN3%TYPE,
46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,
47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,
48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,
49: score_model_id AR_CMGT_CREDIT_REQUESTS.SCORE_MODEL_ID%TYPE,
50: parent_credit_request_id AR_CMGT_CREDIT_REQUESTS.PARENT_CREDIT_REQUEST_ID%TYPE,
51: credit_request_type AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_TYPE%TYPE
52: );
53: --Added Bug 5647107 ssdeshpa start

Line 50: parent_credit_request_id AR_CMGT_CREDIT_REQUESTS.PARENT_CREDIT_REQUEST_ID%TYPE,

46: credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE,
47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,
48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,
49: score_model_id AR_CMGT_CREDIT_REQUESTS.SCORE_MODEL_ID%TYPE,
50: parent_credit_request_id AR_CMGT_CREDIT_REQUESTS.PARENT_CREDIT_REQUEST_ID%TYPE,
51: credit_request_type AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_TYPE%TYPE
52: );
53: --Added Bug 5647107 ssdeshpa start
54: -----------------------------------

Line 51: credit_request_type AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_TYPE%TYPE

47: review_cycle AR_CMGT_CREDIT_REQUESTS.REVIEW_CYCLE%TYPE,
48: case_folder_number AR_CMGT_CREDIT_REQUESTS.CASE_FOLDER_NUMBER%TYPE,
49: score_model_id AR_CMGT_CREDIT_REQUESTS.SCORE_MODEL_ID%TYPE,
50: parent_credit_request_id AR_CMGT_CREDIT_REQUESTS.PARENT_CREDIT_REQUEST_ID%TYPE,
51: credit_request_type AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_TYPE%TYPE
52: );
53: --Added Bug 5647107 ssdeshpa start
54: -----------------------------------
55: -- PROCEDURE validate_le_id

Line 192: , AR_CMGT_CREDIT_REQUESTS CCR

188: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
189: SELECT RCM.CREDIT_RECOMMENDATION
190: , RCM.STATUS
191: FROM AR_CMGT_CF_RECOMMENDS RCM
192: , AR_CMGT_CREDIT_REQUESTS CCR
193: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
194: AND RCM.CREDIT_RECOMMENDATION IN ('REJECT', 'APPROVE')
195: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
196: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 290: , AR_CMGT_CREDIT_REQUESTS CCR

286: --given Lease Application
287: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
288: SELECT COUNT(*)
289: FROM AR_CMGT_CF_RECOMMENDS RCM
290: , AR_CMGT_CREDIT_REQUESTS CCR
291: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
292: AND RCM.CREDIT_RECOMMENDATION IN ('APPROVE', 'EXPIRATION_DATE')
293: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
294: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 302: , AR_CMGT_CREDIT_REQUESTS CCR

298: CURSOR case_folder_csr(p_lap_id NUMBER)
299: IS
300: SELECT LAP.CR_EXP_DAYS + TRUNC(LAST_UPDATED) APPR_EXP_DATE
301: FROM AR_CMGT_CASE_FOLDERS CCF
302: , AR_CMGT_CREDIT_REQUESTS CCR
303: , OKL_LEASE_APPLICATIONS_B LAP
304: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
305: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
306: AND CCR.SOURCE_COLUMN1 = LAP.ID

Line 385: , AR_CMGT_CREDIT_REQUESTS CCR

381: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
382: SELECT RCM.CREDIT_RECOMMENDATION
383: , RCM.APPEALED_FLAG
384: FROM AR_CMGT_CF_RECOMMENDS RCM
385: , AR_CMGT_CREDIT_REQUESTS CCR
386: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
387: AND RCM.CREDIT_RECOMMENDATION IN ('REJECT', 'APPROVE')
388: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
389: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 450: , AR_CMGT_CREDIT_REQUESTS CCR

446: --given Lease Application
447: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
448: SELECT COUNT(*)
449: FROM AR_CMGT_CF_RECOMMENDS RCM
450: , AR_CMGT_CREDIT_REQUESTS CCR
451: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
452: AND RCM.CREDIT_RECOMMENDATION IN ('APPROVE', 'EXPIRATION_DATE')
453: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
454: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 462: , AR_CMGT_CREDIT_REQUESTS CCR

458: CURSOR appeal_flag_csr(p_lap_id NUMBER)
459: IS
460: SELECT RCM.APPEALED_FLAG
461: FROM AR_CMGT_CF_RECOMMENDS RCM
462: , AR_CMGT_CREDIT_REQUESTS CCR
463: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
464: AND RCM.CREDIT_RECOMMENDATION = 'EXPIRATION_DATE'
465: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
466: AND CCR.SOURCE_COLUMN1 = p_lap_id;

Line 3611: FROM AR_CMGT_CREDIT_REQUESTS

3607: ,SOURCE_COLUMN2
3608: ,REVIEW_TYPE
3609: ,CREDIT_CLASSIFICATION
3610: ,CUST_ACCOUNT_ID
3611: FROM AR_CMGT_CREDIT_REQUESTS
3612: WHERE SOURCE_COLUMN3 = 'LEASEAPP'
3613: AND SOURCE_COLUMN1 = cp_lap_id;
3614: get_crd_app_data_rec get_crd_app_data%ROWTYPE;
3615: --asawanka Bug 4865418 changes end

Line 6456: FROM AR_CMGT_CREDIT_REQUESTS ACR

6452:
6453: --Cursor to obtain Credit Request Details
6454: CURSOR acr_dtls_csr(cp_lap_id NUMBER) IS
6455: SELECT CREDIT_REQUEST_ID CREDIT_REQUEST_ID
6456: FROM AR_CMGT_CREDIT_REQUESTS ACR
6457: WHERE ACR.SOURCE_COLUMN3 = 'LEASEAPP' -- Fix for Bug 4749255
6458: AND ACR.SOURCE_COLUMN1 = cp_lap_id;
6459: acr_dtls_rec acr_dtls_csr%ROWTYPE;
6460:

Line 6476: , AR_CMGT_CREDIT_REQUESTS CCR

6472: --Cursor to check whether a given recommendation is added to given Lease App
6473: CURSOR credit_recom_csr(p_lap_id NUMBER, p_recomm VARCHAR2, p_appeal VARCHAR2) IS
6474: SELECT COUNT(*)
6475: FROM AR_CMGT_CF_RECOMMENDS RCM
6476: , AR_CMGT_CREDIT_REQUESTS CCR
6477: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
6478: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
6479: AND RCM.CREDIT_RECOMMENDATION = NVL(p_recomm, RCM.CREDIT_RECOMMENDATION)
6480: AND NVL(RCM.APPEALED_FLAG, 'N') = NVL(p_appeal, NVL(RCM.APPEALED_FLAG, 'N'))

Line 6488: , AR_CMGT_CREDIT_REQUESTS CCR

6484: CURSOR appeal_exp_date_csr(p_lap_id NUMBER)
6485: IS
6486: SELECT RCM.RECOMMENDATION_VALUE1 + TRUNC(LAST_UPDATED) APPEAL_EXP_DATE
6487: FROM AR_CMGT_CASE_FOLDERS CCF
6488: , AR_CMGT_CREDIT_REQUESTS CCR
6489: , AR_CMGT_CF_RECOMMENDS RCM
6490: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
6491: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
6492: AND CCF.STATUS = 'CLOSED'

Line 6794: /* UPDATE AR_CMGT_CREDIT_REQUESTS

6790:
6791: --11/05/05 SNAMBIAR - we should not update other teams table like this
6792: --changing the update statement and calling the API.
6793: --This API will take care of the business event also.
6794: /* UPDATE AR_CMGT_CREDIT_REQUESTS
6795: SET status = 'SUBMIT'
6796: WHERE credit_request_id= acr_dtls_rec.credit_request_id;
6797:
6798: AR_CMGT_WF_ENGINE.START_WORKFLOW(

Line 7427: l_cr_class ar_cmgt_credit_requests.credit_classification%type;

7423: RETURN VARCHAR2
7424: IS
7425: -- Variables Declarations
7426: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'GET_CREDIT_CLASSFICATION';
7427: l_cr_class ar_cmgt_credit_requests.credit_classification%type;
7428: l_party_id NUMBER;
7429: l_cust_acct_id NUMBER;
7430: l_site_use_id NUMBER;
7431:

Line 8021: , AR_CMGT_CREDIT_REQUESTS CCR

8017: --given Lease Application
8018: CURSOR credit_recom_csr(cp_lap_id NUMBER, p_recom VARCHAR2) IS
8019: SELECT COUNT(*)
8020: FROM AR_CMGT_CF_RECOMMENDS RCM
8021: , AR_CMGT_CREDIT_REQUESTS CCR
8022: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
8023: AND RCM.CREDIT_RECOMMENDATION = p_recom
8024: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
8025: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 8044: , AR_CMGT_CREDIT_REQUESTS CCR

8040: CURSOR ocm_counter_offer_csr(cp_lap_id NUMBER, cp_co_id NUMBER)
8041: IS
8042: SELECT 'X'
8043: FROM AR_CMGT_CF_RECOMMENDS CCRM
8044: , AR_CMGT_CREDIT_REQUESTS CCR
8045: WHERE CCRM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
8046: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
8047: AND CCRM.CREDIT_RECOMMENDATION = 'COUNTER_OFFER'
8048: AND CCR.SOURCE_COLUMN1 = cp_lap_id

Line 8349: , AR_CMGT_CREDIT_REQUESTS CRR

8345: SELECT LSQ.ID LSQ_ID
8346: , CRR.CREDIT_REQUEST_ID
8347: FROM OKL_LEASE_QUOTES_B LSQ
8348: , OKL_LEASE_APPLICATIONS_B LAP
8349: , AR_CMGT_CREDIT_REQUESTS CRR
8350: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
8351: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
8352: AND LSQ.PRIMARY_QUOTE = 'Y'
8353: AND CRR.SOURCE_COLUMN1 = LAP.ID

Line 9159: , AR_CMGT_CREDIT_REQUESTS CRR

9155: , LAP.APPLICATION_STATUS
9156: , LAP.APPLICATION_STATUS APPEAL_SCOPE
9157: FROM OKL_LEASE_QUOTES_B LSQ
9158: , OKL_LEASE_APPLICATIONS_B LAP
9159: , AR_CMGT_CREDIT_REQUESTS CRR
9160: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
9161: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
9162: AND LSQ.PRIMARY_QUOTE = 'Y'
9163: AND CRR.SOURCE_COLUMN1 = LAP.ID

Line 9629: , AR_CMGT_CREDIT_REQUESTS CCR

9625: --Cursor to check whether a given recommendation is added to given Lease App
9626: CURSOR credit_recom_csr(p_lap_id NUMBER, p_recomm VARCHAR2) IS
9627: SELECT COUNT(*)
9628: FROM AR_CMGT_CF_RECOMMENDS RCM
9629: , AR_CMGT_CREDIT_REQUESTS CCR
9630: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
9631: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
9632: AND RCM.CREDIT_RECOMMENDATION = p_recomm
9633: AND CCR.SOURCE_COLUMN1 = p_lap_id;

Line 9640: , AR_CMGT_CREDIT_REQUESTS CCR

9636: CURSOR appeal_exp_date_csr(p_lap_id NUMBER)
9637: IS
9638: SELECT RCM.RECOMMENDATION_VALUE1 + TRUNC(LAST_UPDATED) APPEAL_EXP_DATE
9639: FROM AR_CMGT_CASE_FOLDERS CCF
9640: , AR_CMGT_CREDIT_REQUESTS CCR
9641: , AR_CMGT_CF_RECOMMENDS RCM
9642: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
9643: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
9644: AND CCF.STATUS = 'CLOSED'

Line 11302: , AR_CMGT_CREDIT_REQUESTS CCR

11298: , RCM.CREDIT_RECOMMENDATION
11299: , RCM.RECOMMENDATION_NAME
11300: , RCM.APPEALED_FLAG
11301: FROM AR_CMGT_CF_RECOMMENDS RCM
11302: , AR_CMGT_CREDIT_REQUESTS CCR
11303: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
11304: AND RCM.CREDIT_RECOMMENDATION = NVL(cp_cr_recom, RCM.CREDIT_RECOMMENDATION)
11305: AND RCM.RECOMMENDATION_ID = NVL(cp_recom_id, RCM.RECOMMENDATION_ID)
11306: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 11325: FROM AR_CMGT_CREDIT_REQUESTS CCR

11321: , CCR.REVIEW_TYPE
11322: , CCR.CREDIT_CLASSIFICATION
11323: , CCR.CUST_ACCOUNT_ID
11324: , LAB.PARENT_LEASEAPP_ID PARENT_LEASEAPP_ID
11325: FROM AR_CMGT_CREDIT_REQUESTS CCR
11326: , OKL_LEASE_APPLICATIONS_B LAB
11327: WHERE SOURCE_COLUMN3 = 'LEASEAPP'
11328: AND SOURCE_COLUMN1 = LAB.PARENT_LEASEAPP_ID
11329: AND LAB.ID = cp_lap_id;