APPS.ZX_AP_ACTG_POPULATE_PKG dependencies on ZX_REC_NREC_DIST

Line 549: FROM zx_rec_nrec_dist zx_dist,

545:
546: CURSOR trx_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
547: SELECT
548: ael.code_combination_id
549: FROM zx_rec_nrec_dist zx_dist,
550: xla_distribution_links lnk,
551: xla_ae_lines ael
552: WHERE zx_dist.trx_id = c_trx_id
553: AND lnk.application_id = 200

Line 569: FROM zx_rec_nrec_dist zx_dist,

565: c_event_id NUMBER,
566: c_ae_header_id NUMBER) IS
567: SELECT
568: ael.code_combination_id
569: FROM zx_rec_nrec_dist zx_dist,
570: xla_distribution_links lnk,
571: xla_ae_lines ael
572: WHERE zx_dist.trx_id = c_trx_id
573: AND zx_dist.trx_line_id = c_trx_line_id

Line 590: FROM zx_rec_nrec_dist zx_dist,

586:
587: CURSOR trx_dist_ccid (c_trx_id NUMBER, c_trx_line_id NUMBER, c_event_id NUMBER, c_ae_header_id NUMBER) IS
588: SELECT
589: ael.code_combination_id
590: FROM zx_rec_nrec_dist zx_dist,
591: xla_distribution_links lnk,
592: xla_ae_lines ael
593: WHERE zx_dist.trx_id = c_trx_id
594: AND zx_dist.trx_line_id = c_trx_line_id

Line 609: FROM zx_rec_nrec_dist zx_dist,

605:
606: CURSOR tax_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
607: SELECT
608: ael.code_combination_id
609: FROM zx_rec_nrec_dist zx_dist,
610: xla_distribution_links lnk,
611: xla_ae_lines ael
612: WHERE zx_dist.trx_id = c_trx_id
613: AND lnk.application_id = 200

Line 626: FROM zx_rec_nrec_dist zx_dist,

622:
623: CURSOR tax_line_ccid (c_trx_id number, c_tax_line_id NUMBER, c_event_id number, c_ae_header_id number) IS
624: SELECT
625: ael.code_combination_id
626: FROM zx_rec_nrec_dist zx_dist,
627: xla_distribution_links lnk,
628: xla_ae_lines ael
629: WHERE zx_dist.trx_id = c_trx_id
630: AND zx_dist.tax_line_id = c_tax_line_id

Line 648: FROM zx_rec_nrec_dist zx_dist,

644: CURSOR tax_dist_ccid (c_trx_id NUMBER, c_tax_line_id NUMBER, c_tax_line_dist_id NUMBER,
645: c_event_id number, c_ae_header_id number) IS
646: SELECT
647: ael.code_combination_id
648: FROM zx_rec_nrec_dist zx_dist,
649: xla_distribution_links lnk,
650: xla_ae_lines ael
651: WHERE zx_dist.trx_id = c_trx_id
652: AND zx_dist.tax_line_id = c_tax_line_id

Line 976: FROM zx_rec_nrec_dist zx_dist,

972: -- Transaction Header Level
973:
974: CURSOR taxable_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
975: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
976: FROM zx_rec_nrec_dist zx_dist,
977: xla_distribution_links lnk,
978: xla_ae_headers aeh,
979: xla_ae_lines ael
980: WHERE zx_dist.trx_id = c_trx_id

Line 994: FROM zx_rec_nrec_dist zx_dist,

990:
991:
992: CURSOR tax_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
993: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
994: FROM zx_rec_nrec_dist zx_dist,
995: xla_distribution_links lnk,
996: xla_ae_headers aeh,
997: xla_ae_lines ael
998: WHERE zx_dist.trx_id = c_trx_id

Line 1014: FROM zx_rec_nrec_dist zx_dist,

1010:
1011: CURSOR taxable_amount_line (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
1012: c_event_id NUMBER, c_ledger_id NUMBER) IS
1013: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1014: FROM zx_rec_nrec_dist zx_dist,
1015: xla_distribution_links lnk,
1016: xla_ae_headers aeh,
1017: xla_ae_lines ael
1018: WHERE zx_dist.trx_id = c_trx_id

Line 1033: FROM zx_rec_nrec_dist zx_dist,

1029:
1030: CURSOR tax_amount_line (c_trx_id NUMBER,c_tax_line_id NUMBER, c_ae_header_id NUMBER,
1031: c_event_id NUMBER, c_ledger_id NUMBER) IS
1032: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1033: FROM zx_rec_nrec_dist zx_dist,
1034: xla_distribution_links lnk,
1035: xla_ae_headers aeh,
1036: xla_ae_lines ael
1037: WHERE zx_dist.trx_id = c_trx_id

Line 1056: FROM zx_rec_nrec_dist zx_dist,

1052:
1053: CURSOR tax_amount_dist ( c_trx_id NUMBER,c_tax_line_id NUMBER, c_tax_dist_id NUMBER, c_ae_header_id NUMBER,
1054: c_event_id NUMBER, c_ledger_id NUMBER) IS
1055: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1056: FROM zx_rec_nrec_dist zx_dist,
1057: xla_distribution_links lnk,
1058: xla_ae_headers aeh,
1059: xla_ae_lines ael
1060: WHERE zx_dist.trx_id = c_trx_id

Line 1076: FROM zx_rec_nrec_dist zx_dist,

1072:
1073: CURSOR taxable_amount_dist (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
1074: c_event_id NUMBER, c_ledger_id NUMBER) IS
1075: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1076: FROM zx_rec_nrec_dist zx_dist,
1077: xla_distribution_links lnk,
1078: xla_ae_headers aeh,
1079: xla_ae_lines ael
1080: WHERE zx_dist.trx_id = c_trx_id