eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_BC_ALLOC_V

Line 9850: FROM psa_bc_alloc_v a,

9846: WHERE EXISTS
9847: (
9848: SELECT
9849: 'Related transaction allocation setup exists'
9850: FROM psa_bc_alloc_v a,
9851: psa_bc_alloc_v b
9852: WHERE a.ROW_ID <> b.ROW_ID
9853: AND a.ledger_id=p_ledgerid
9854: AND b.ledger_id=p_ledgerid

Line 9851: psa_bc_alloc_v b

9847: (
9848: SELECT
9849: 'Related transaction allocation setup exists'
9850: FROM psa_bc_alloc_v a,
9851: psa_bc_alloc_v b
9852: WHERE a.ROW_ID <> b.ROW_ID
9853: AND a.ledger_id=p_ledgerid
9854: AND b.ledger_id=p_ledgerid
9855: AND NVL (b.alloc_to_entity_code, 'X') = NVL (a.entity_code, 'X')

Line 9881: FROM psa_bc_alloc_v a,

9877: AND EXISTS
9878: (
9879: SELECT
9880: 'Parent transaction allocation setup exists'
9881: FROM psa_bc_alloc_v a,
9882: psa_bc_alloc_v b
9883: WHERE a.ROW_ID = b.ROW_ID
9884: AND a.ledger_id=p_ledgerid
9885: AND b.ledger_id=p_ledgerid

Line 9882: psa_bc_alloc_v b

9878: (
9879: SELECT
9880: 'Parent transaction allocation setup exists'
9881: FROM psa_bc_alloc_v a,
9882: psa_bc_alloc_v b
9883: WHERE a.ROW_ID = b.ROW_ID
9884: AND a.ledger_id=p_ledgerid
9885: AND b.ledger_id=p_ledgerid
9886: AND NVL (b.alloc_to_entity_code, 'X') = NVL (a.entity_code, 'X')

Line 9937: FROM psa_bc_alloc_v a

9933: SOURCE_DISTRIBUTION_ID_CHAR_2 ,
9934: SOURCE_DISTRIBUTION_ID_CHAR_3 ,
9935: SOURCE_DISTRIBUTION_ID_CHAR_4 ,
9936: SOURCE_DISTRIBUTION_ID_CHAR_5
9937: FROM psa_bc_alloc_v a
9938: WHERE EXISTS
9939: (
9940: SELECT
9941: 'Accounting line is allocated to itself'

Line 9942: FROM psa_bc_alloc_v b

9938: WHERE EXISTS
9939: (
9940: SELECT
9941: 'Accounting line is allocated to itself'
9942: FROM psa_bc_alloc_v b
9943: WHERE b.ROW_ID = a.ROW_ID
9944: AND NVL(b.ALLOC_TO_ENTITY_CODE, 'X') = NVL(a.ENTITY_CODE, 'X')
9945: AND NVL(b.ALLOC_TO_SOURCE_ID_NUM_1, -99)= NVL(a.SOURCE_ID_INT_1, -99)
9946: AND NVL(b.ALLOC_TO_SOURCE_ID_NUM_2, -99) = NVL(a.SOURCE_ID_INT_2, -99)

Line 9995: FROM psa_bc_alloc_v

9991: SELECT
9992: ae_header_id,
9993: ae_line_num,
9994: event_id
9995: FROM psa_bc_alloc_v
9996: WHERE NVL(ALLOC_TO_ENTITY_CODE, 'X') = NVL(p_entity_code, 'X')
9997: AND NVL(ALLOC_TO_SOURCE_ID_NUM_1, -99) = NVL(p_source_id_int_1, -99)
9998: AND NVL(ALLOC_TO_SOURCE_ID_NUM_2, -99) = NVL(p_source_id_int_2, -99)
9999: AND NVL(ALLOC_TO_SOURCE_ID_NUM_3, -99) = NVL(p_source_id_int_3, -99)