DBA Data[Home] [Help]

APPS.PA_UTILS2 dependencies on PA_LOOKUPS

Line 1390: FROM PA_Lookups LOOK

1386: * as parameter.
1387: */
1388: SELECT Meaning
1389: INTO l_reject_meaning
1390: FROM PA_Lookups LOOK
1391: WHERE LOOK.Lookup_Type = 'TRANSFER REJECTION CODE'
1392: AND LOOK.Lookup_Code = 'TRANS_INV_DATA';
1393:
1394: FORALL i IN 1..p_local_set_size

Line 1565: FROM PA_Lookups LOOK

1561: )
1562: ,CDL.Transfer_Rejection_Reason =
1563: (
1564: SELECT Meaning
1565: FROM PA_Lookups LOOK
1566: WHERE LOOK.Lookup_Type = 'TRANSFER REJECTION CODE'
1567: AND LOOK.Lookup_Code = Decode(l_interface_to_gl(i),'Y'
1568: ,DECODE(l_gl_date_new(i),NULL,'NO_GL_DATE'
1569: ,DECODE(l_recvr_gl_date_new(i),NULL,'NO_RECVR_GL_DATE',NULL)),NULL)

Line 1632: FROM PA_Lookups LOOK

1628: ,'Y')))
1629: ,CDL.Transfer_Rejection_Reason = -- Bug 3669746
1630: (
1631: SELECT Meaning
1632: FROM PA_Lookups LOOK
1633: WHERE LOOK.Lookup_Type = 'TRANSFER REJECTION CODE'
1634: AND LOOK.Lookup_Code = DECODE(l_gl_date_new(i)
1635: , NULL,'NO_GL_DATE'
1636: ,DECODE(l_recvr_gl_date_new(i)