APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_BC_ALLOC_V

Line 9579: FROM psa_bc_alloc_v a,

9575: WHERE EXISTS
9576: (
9577: SELECT
9578: 'Related transaction allocation setup exists'
9579: FROM psa_bc_alloc_v a,
9580: psa_bc_alloc_v b
9581: WHERE a.ROW_ID <> b.ROW_ID
9582: AND NVL (b.alloc_to_entity_code, 'X') = NVL (a.entity_code, 'X')
9583: AND NVL (b.alloc_to_source_id_num_1, -99) = NVL (a.source_id_int_1, -99)

Line 9580: psa_bc_alloc_v b

9576: (
9577: SELECT
9578: 'Related transaction allocation setup exists'
9579: FROM psa_bc_alloc_v a,
9580: psa_bc_alloc_v b
9581: WHERE a.ROW_ID <> b.ROW_ID
9582: AND NVL (b.alloc_to_entity_code, 'X') = NVL (a.entity_code, 'X')
9583: AND NVL (b.alloc_to_source_id_num_1, -99) = NVL (a.source_id_int_1, -99)
9584: AND NVL (b.alloc_to_source_id_num_2, -99) = NVL (a.source_id_int_2, -99)

Line 9608: FROM psa_bc_alloc_v a,

9604: AND EXISTS
9605: (
9606: SELECT
9607: 'Parent transaction allocation setup exists'
9608: FROM psa_bc_alloc_v a,
9609: psa_bc_alloc_v b
9610: WHERE a.ROW_ID = b.ROW_ID
9611: AND NVL (b.alloc_to_entity_code, 'X') = NVL (a.entity_code, 'X')
9612: AND NVL (b.alloc_to_source_id_num_1, -99) = NVL (a.source_id_int_1, -99)

Line 9609: psa_bc_alloc_v b

9605: (
9606: SELECT
9607: 'Parent transaction allocation setup exists'
9608: FROM psa_bc_alloc_v a,
9609: psa_bc_alloc_v b
9610: WHERE a.ROW_ID = b.ROW_ID
9611: AND NVL (b.alloc_to_entity_code, 'X') = NVL (a.entity_code, 'X')
9612: AND NVL (b.alloc_to_source_id_num_1, -99) = NVL (a.source_id_int_1, -99)
9613: AND NVL (b.alloc_to_source_id_num_2, -99) = NVL (a.source_id_int_2, -99)

Line 9662: FROM psa_bc_alloc_v a

9658: SOURCE_DISTRIBUTION_ID_CHAR_2 ,
9659: SOURCE_DISTRIBUTION_ID_CHAR_3 ,
9660: SOURCE_DISTRIBUTION_ID_CHAR_4 ,
9661: SOURCE_DISTRIBUTION_ID_CHAR_5
9662: FROM psa_bc_alloc_v a
9663: WHERE EXISTS
9664: (
9665: SELECT
9666: 'Accounting line is allocated to itself'

Line 9667: FROM psa_bc_alloc_v b

9663: WHERE EXISTS
9664: (
9665: SELECT
9666: 'Accounting line is allocated to itself'
9667: FROM psa_bc_alloc_v b
9668: WHERE b.ROW_ID = a.ROW_ID
9669: AND NVL(b.ALLOC_TO_ENTITY_CODE, 'X') = NVL(a.ENTITY_CODE, 'X')
9670: AND NVL(b.ALLOC_TO_SOURCE_ID_NUM_1, -99)= NVL(a.SOURCE_ID_INT_1, -99)
9671: AND NVL(b.ALLOC_TO_SOURCE_ID_NUM_2, -99) = NVL(a.SOURCE_ID_INT_2, -99)

Line 9720: FROM psa_bc_alloc_v

9716: SELECT
9717: ae_header_id,
9718: ae_line_num,
9719: event_id
9720: FROM psa_bc_alloc_v
9721: WHERE NVL(ALLOC_TO_ENTITY_CODE, 'X') = NVL(p_entity_code, 'X')
9722: AND NVL(ALLOC_TO_SOURCE_ID_NUM_1, -99) = NVL(p_source_id_int_1, -99)
9723: AND NVL(ALLOC_TO_SOURCE_ID_NUM_2, -99) = NVL(p_source_id_int_2, -99)
9724: AND NVL(ALLOC_TO_SOURCE_ID_NUM_3, -99) = NVL(p_source_id_int_3, -99)