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 234: , AR_CMGT_CREDIT_REQUESTS CCR

230: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
231: SELECT RCM.CREDIT_RECOMMENDATION
232: , RCM.STATUS
233: FROM AR_CMGT_CF_RECOMMENDS RCM
234: , AR_CMGT_CREDIT_REQUESTS CCR
235: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
236: AND RCM.CREDIT_RECOMMENDATION IN ('REJECT', 'APPROVE')
237: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
238: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 332: , AR_CMGT_CREDIT_REQUESTS CCR

328: --given Lease Application
329: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
330: SELECT COUNT(*)
331: FROM AR_CMGT_CF_RECOMMENDS RCM
332: , AR_CMGT_CREDIT_REQUESTS CCR
333: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
334: AND RCM.CREDIT_RECOMMENDATION IN ('APPROVE', 'EXPIRATION_DATE')
335: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
336: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 344: , AR_CMGT_CREDIT_REQUESTS CCR

340: CURSOR case_folder_csr(p_lap_id NUMBER)
341: IS
342: SELECT LAP.CR_EXP_DAYS + TRUNC(LAST_UPDATED) APPR_EXP_DATE
343: FROM AR_CMGT_CASE_FOLDERS CCF
344: , AR_CMGT_CREDIT_REQUESTS CCR
345: , OKL_LEASE_APPLICATIONS_B LAP
346: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
347: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
348: AND CCR.SOURCE_COLUMN1 = LAP.ID

Line 427: , AR_CMGT_CREDIT_REQUESTS CCR

423: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
424: SELECT RCM.CREDIT_RECOMMENDATION
425: , RCM.APPEALED_FLAG
426: FROM AR_CMGT_CF_RECOMMENDS RCM
427: , AR_CMGT_CREDIT_REQUESTS CCR
428: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
429: AND RCM.CREDIT_RECOMMENDATION IN ('REJECT', 'APPROVE')
430: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
431: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 492: , AR_CMGT_CREDIT_REQUESTS CCR

488: --given Lease Application
489: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
490: SELECT COUNT(*)
491: FROM AR_CMGT_CF_RECOMMENDS RCM
492: , AR_CMGT_CREDIT_REQUESTS CCR
493: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
494: AND RCM.CREDIT_RECOMMENDATION IN ('APPROVE', 'EXPIRATION_DATE')
495: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
496: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 504: , AR_CMGT_CREDIT_REQUESTS CCR

500: CURSOR appeal_flag_csr(p_lap_id NUMBER)
501: IS
502: SELECT RCM.APPEALED_FLAG
503: FROM AR_CMGT_CF_RECOMMENDS RCM
504: , AR_CMGT_CREDIT_REQUESTS CCR
505: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
506: AND RCM.CREDIT_RECOMMENDATION = 'EXPIRATION_DATE'
507: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
508: AND CCR.SOURCE_COLUMN1 = p_lap_id;

Line 3699: FROM AR_CMGT_CREDIT_REQUESTS

3695: ,SOURCE_COLUMN2
3696: ,REVIEW_TYPE
3697: ,CREDIT_CLASSIFICATION
3698: ,CUST_ACCOUNT_ID
3699: FROM AR_CMGT_CREDIT_REQUESTS
3700: WHERE SOURCE_COLUMN3 = 'LEASEAPP'
3701: AND SOURCE_COLUMN1 = cp_lap_id;
3702: get_crd_app_data_rec get_crd_app_data%ROWTYPE;
3703: --asawanka Bug 4865418 changes end

Line 6587: FROM AR_CMGT_CREDIT_REQUESTS ACR

6583:
6584: --Cursor to obtain Credit Request Details
6585: CURSOR acr_dtls_csr(cp_lap_id NUMBER) IS
6586: SELECT CREDIT_REQUEST_ID CREDIT_REQUEST_ID
6587: FROM AR_CMGT_CREDIT_REQUESTS ACR
6588: WHERE ACR.SOURCE_COLUMN3 = 'LEASEAPP' -- Fix for Bug 4749255
6589: AND ACR.SOURCE_COLUMN1 = cp_lap_id;
6590: acr_dtls_rec acr_dtls_csr%ROWTYPE;
6591:

Line 6607: , AR_CMGT_CREDIT_REQUESTS CCR

6603: --Cursor to check whether a given recommendation is added to given Lease App
6604: CURSOR credit_recom_csr(p_lap_id NUMBER, p_recomm VARCHAR2, p_appeal VARCHAR2) IS
6605: SELECT COUNT(*)
6606: FROM AR_CMGT_CF_RECOMMENDS RCM
6607: , AR_CMGT_CREDIT_REQUESTS CCR
6608: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
6609: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
6610: AND RCM.CREDIT_RECOMMENDATION = NVL(p_recomm, RCM.CREDIT_RECOMMENDATION)
6611: AND NVL(RCM.APPEALED_FLAG, 'N') = NVL(p_appeal, NVL(RCM.APPEALED_FLAG, 'N'))

Line 6619: , AR_CMGT_CREDIT_REQUESTS CCR

6615: CURSOR appeal_exp_date_csr(p_lap_id NUMBER)
6616: IS
6617: SELECT RCM.RECOMMENDATION_VALUE1 + TRUNC(LAST_UPDATED) APPEAL_EXP_DATE
6618: FROM AR_CMGT_CASE_FOLDERS CCF
6619: , AR_CMGT_CREDIT_REQUESTS CCR
6620: , AR_CMGT_CF_RECOMMENDS RCM
6621: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
6622: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
6623: AND CCF.STATUS = 'CLOSED'

Line 6925: /* UPDATE AR_CMGT_CREDIT_REQUESTS

6921:
6922: --11/05/05 SNAMBIAR - we should not update other teams table like this
6923: --changing the update statement and calling the API.
6924: --This API will take care of the business event also.
6925: /* UPDATE AR_CMGT_CREDIT_REQUESTS
6926: SET status = 'SUBMIT'
6927: WHERE credit_request_id= acr_dtls_rec.credit_request_id;
6928:
6929: AR_CMGT_WF_ENGINE.START_WORKFLOW(

Line 7558: l_cr_class ar_cmgt_credit_requests.credit_classification%type;

7554: RETURN VARCHAR2
7555: IS
7556: -- Variables Declarations
7557: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'GET_CREDIT_CLASSFICATION';
7558: l_cr_class ar_cmgt_credit_requests.credit_classification%type;
7559: l_party_id NUMBER;
7560: l_cust_acct_id NUMBER;
7561: l_site_use_id NUMBER;
7562:

Line 8152: , AR_CMGT_CREDIT_REQUESTS CCR

8148: --given Lease Application
8149: CURSOR credit_recom_csr(cp_lap_id NUMBER, p_recom VARCHAR2) IS
8150: SELECT COUNT(*)
8151: FROM AR_CMGT_CF_RECOMMENDS RCM
8152: , AR_CMGT_CREDIT_REQUESTS CCR
8153: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
8154: AND RCM.CREDIT_RECOMMENDATION = p_recom
8155: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
8156: AND CCR.SOURCE_COLUMN1 = cp_lap_id;

Line 8175: , AR_CMGT_CREDIT_REQUESTS CCR

8171: CURSOR ocm_counter_offer_csr(cp_lap_id NUMBER, cp_co_id NUMBER)
8172: IS
8173: SELECT 'X'
8174: FROM AR_CMGT_CF_RECOMMENDS CCRM
8175: , AR_CMGT_CREDIT_REQUESTS CCR
8176: WHERE CCRM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
8177: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
8178: AND CCRM.CREDIT_RECOMMENDATION = 'COUNTER_OFFER'
8179: AND CCR.SOURCE_COLUMN1 = cp_lap_id

Line 8480: , AR_CMGT_CREDIT_REQUESTS CRR

8476: SELECT LSQ.ID LSQ_ID
8477: , CRR.CREDIT_REQUEST_ID
8478: FROM OKL_LEASE_QUOTES_B LSQ
8479: , OKL_LEASE_APPLICATIONS_B LAP
8480: , AR_CMGT_CREDIT_REQUESTS CRR
8481: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
8482: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
8483: AND LSQ.PRIMARY_QUOTE = 'Y'
8484: AND CRR.SOURCE_COLUMN1 = LAP.ID

Line 9290: , AR_CMGT_CREDIT_REQUESTS CRR

9286: , LAP.APPLICATION_STATUS
9287: , LAP.APPLICATION_STATUS APPEAL_SCOPE
9288: FROM OKL_LEASE_QUOTES_B LSQ
9289: , OKL_LEASE_APPLICATIONS_B LAP
9290: , AR_CMGT_CREDIT_REQUESTS CRR
9291: WHERE LSQ.PARENT_OBJECT_ID = LAP.ID
9292: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
9293: AND LSQ.PRIMARY_QUOTE = 'Y'
9294: AND CRR.SOURCE_COLUMN1 = LAP.ID

Line 9760: , AR_CMGT_CREDIT_REQUESTS CCR

9756: --Cursor to check whether a given recommendation is added to given Lease App
9757: CURSOR credit_recom_csr(p_lap_id NUMBER, p_recomm VARCHAR2) IS
9758: SELECT COUNT(*)
9759: FROM AR_CMGT_CF_RECOMMENDS RCM
9760: , AR_CMGT_CREDIT_REQUESTS CCR
9761: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
9762: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
9763: AND RCM.CREDIT_RECOMMENDATION = p_recomm
9764: AND CCR.SOURCE_COLUMN1 = p_lap_id;

Line 9771: , AR_CMGT_CREDIT_REQUESTS CCR

9767: CURSOR appeal_exp_date_csr(p_lap_id NUMBER)
9768: IS
9769: SELECT RCM.RECOMMENDATION_VALUE1 + TRUNC(LAST_UPDATED) APPEAL_EXP_DATE
9770: FROM AR_CMGT_CASE_FOLDERS CCF
9771: , AR_CMGT_CREDIT_REQUESTS CCR
9772: , AR_CMGT_CF_RECOMMENDS RCM
9773: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
9774: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
9775: AND CCF.STATUS = 'CLOSED'

Line 11454: , AR_CMGT_CREDIT_REQUESTS CCR

11450: , RCM.CREDIT_RECOMMENDATION
11451: , RCM.RECOMMENDATION_NAME
11452: , RCM.APPEALED_FLAG
11453: FROM AR_CMGT_CF_RECOMMENDS RCM
11454: , AR_CMGT_CREDIT_REQUESTS CCR
11455: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
11456: AND RCM.CREDIT_RECOMMENDATION = NVL(cp_cr_recom, RCM.CREDIT_RECOMMENDATION)
11457: AND RCM.RECOMMENDATION_ID = NVL(cp_recom_id, RCM.RECOMMENDATION_ID)
11458: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 11477: FROM AR_CMGT_CREDIT_REQUESTS CCR

11473: , CCR.REVIEW_TYPE
11474: , CCR.CREDIT_CLASSIFICATION
11475: , CCR.CUST_ACCOUNT_ID
11476: , LAB.PARENT_LEASEAPP_ID PARENT_LEASEAPP_ID
11477: FROM AR_CMGT_CREDIT_REQUESTS CCR
11478: , OKL_LEASE_APPLICATIONS_B LAB
11479: WHERE SOURCE_COLUMN3 = 'LEASEAPP'
11480: AND SOURCE_COLUMN1 = LAB.PARENT_LEASEAPP_ID
11481: AND LAB.ID = cp_lap_id;