APPS.ZX_AP_ACTG_POPULATE_PKG dependencies on ZX_REC_NREC_DIST

Line 552: FROM zx_rec_nrec_dist zx_dist,

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

Line 572: FROM zx_rec_nrec_dist zx_dist,

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

Line 593: FROM zx_rec_nrec_dist zx_dist,

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

Line 612: FROM zx_rec_nrec_dist zx_dist,

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

Line 629: FROM zx_rec_nrec_dist zx_dist,

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

Line 651: FROM zx_rec_nrec_dist zx_dist,

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

Line 979: FROM zx_rec_nrec_dist zx_dist,

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

Line 997: FROM zx_rec_nrec_dist zx_dist,

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

Line 1017: FROM zx_rec_nrec_dist zx_dist,

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

Line 1036: FROM zx_rec_nrec_dist zx_dist,

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

Line 1059: FROM zx_rec_nrec_dist zx_dist,

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

Line 1079: FROM zx_rec_nrec_dist zx_dist,

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