APPS.ARP_CASH_BASIS_JE_REPORT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 34: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,

30: -- RECORD holder for pertinent information from a receivable application
31: -- of status = 'APP'
32: TYPE ApplicationType IS RECORD
33: (
34: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
35: GLDate DATE, -- the gl date of the application
36: TrxDate DATE, -- the apply date of the application
37: AppType ar_receivable_applications.application_type%TYPE,
38: CatMeaning ar_lookups.meaning%TYPE,

Line 37: AppType ar_receivable_applications.application_type%TYPE,

33: (
34: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
35: GLDate DATE, -- the gl date of the application
36: TrxDate DATE, -- the apply date of the application
37: AppType ar_receivable_applications.application_type%TYPE,
38: CatMeaning ar_lookups.meaning%TYPE,
39: PostingControlId ar_receivable_applications.posting_control_id%TYPE
40: );
41: --

Line 39: PostingControlId ar_receivable_applications.posting_control_id%TYPE

35: GLDate DATE, -- the gl date of the application
36: TrxDate DATE, -- the apply date of the application
37: AppType ar_receivable_applications.application_type%TYPE,
38: CatMeaning ar_lookups.meaning%TYPE,
39: PostingControlId ar_receivable_applications.posting_control_id%TYPE
40: );
41: --
42: -- holds ApplicationAmount values
43: --

Line 1191: -- post ar_receivable_applications that have status UNAPP, UNID, ACC

1187: RAISE;
1188: END;
1189: --
1190: --
1191: -- post ar_receivable_applications that have status UNAPP, UNID, ACC
1192: --
1193: /*---------------------------------------------------------------------------*
1194: | PRIVATE PROCEDURE |
1195: | ReportNonDistApplications |

Line 1197: | non-APP ar_receivable_applications records |

1193: /*---------------------------------------------------------------------------*
1194: | PRIVATE PROCEDURE |
1195: | ReportNonDistApplications |
1196: | DESCRIPTION |
1197: | non-APP ar_receivable_applications records |
1198: | |
1199: | |
1200: | PARAMETERS |
1201: | |

Line 1231: FROM ar_receivable_applications ra,

1227: ra.code_combination_id CodeCombinationId,
1228: ra.status Status,
1229: l_cat.meaning CatMeaning,
1230: cr.org_id OrgId
1231: FROM ar_receivable_applications ra,
1232: ar_cash_receipts cr,
1233: hz_cust_accounts cust,
1234: ar_lookups l_cat
1235: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom

Line 1287: arp_standard.debug( ' AR_RECEIVABLE_APPLICATIONS (non-app)...' );

1283: l_Count NUMBER :=0;
1284:
1285: BEGIN
1286: arp_standard.debug( ' ' );
1287: arp_standard.debug( ' AR_RECEIVABLE_APPLICATIONS (non-app)...' );
1288: FOR RRa IN CRa
1289: LOOP
1290: -- bug3718694 Call CreateInterim procedure to insert record into
1291: -- ar_journal_interim .

Line 1391: | post unposted ar_receivable_applications records |

1387: | PRIVATE PROCEDURE |
1388: | ReportDistributedApplications |
1389: | |
1390: | DESCRIPTION |
1391: | post unposted ar_receivable_applications records |
1392: | post unposted ar_receivable_applications records |
1393: | We need to have ORDER BY clause in the select statement because |
1394: | when comparing with GL Transfer entries, they need to match, |
1395: | If order by is not used, there will be rounding difference. |

Line 1392: | post unposted ar_receivable_applications records |

1388: | ReportDistributedApplications |
1389: | |
1390: | DESCRIPTION |
1391: | post unposted ar_receivable_applications records |
1392: | post unposted ar_receivable_applications records |
1393: | We need to have ORDER BY clause in the select statement because |
1394: | when comparing with GL Transfer entries, they need to match, |
1395: | If order by is not used, there will be rounding difference. |
1396: | |

Line 1480: FROM ar_receivable_applications ra,

1476: ) ChargesApplied,
1477: l_cat.meaning CatMeaning,
1478: ra.posting_control_id PostingControlId,
1479: ct.org_id OrgID
1480: FROM ar_receivable_applications ra,
1481: ra_cust_trx_types ctt,
1482: ra_customer_trx ct,
1483: ar_cash_receipts cr,
1484: ar_cash_receipt_history crh,

Line 2052: l_ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE;

2048: AND i.reference28 = p_CategoryCode
2049: ORDER BY i.reference30,
2050: i.reference23;
2051: --
2052: l_ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE;
2053: BEGIN
2054: --
2055: arp_standard.debug( ' ----------------------------------------------------' );
2056: arp_standard.debug( ' Checking DR/CR balance...' );