DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000002_PKG dependencies on PSA_CST_XLA_UPG_V

Line 147055: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'

147051: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
147052: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
147053: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
147054: WHEN 14 THEN 'PO_HEADERS_REF_V'
147055: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
147056: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
147057:
147058: ELSE null
147059: END object_name

Line 147152: , PSA_CST_XLA_UPG_V h6

147148: , CST_XLA_RCV_HEADERS_V h1
147149: , CST_XLA_RCV_REF_V h3
147150: , PO_DISTS_REF_V h4
147151: , PO_HEADERS_REF_V h5
147152: , PSA_CST_XLA_UPG_V h6
147153: , fnd_lookup_values fvl12
147154: , fnd_lookup_values fvl38
147155: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
147156: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

147428: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
147429: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
147430: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
147431: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
147432: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
147433: TYPE t_array_source_38 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
147434:
147435: TYPE t_array_source_4 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
147436: TYPE t_array_source_5 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 147518: , PSA_CST_XLA_UPG_V h6

147514: , CST_XLA_RCV_HEADERS_V h1
147515: , CST_XLA_RCV_REF_V h3
147516: , PO_DISTS_REF_V h4
147517: , PO_HEADERS_REF_V h5
147518: , PSA_CST_XLA_UPG_V h6
147519: , fnd_lookup_values fvl12
147520: , fnd_lookup_values fvl38
147521: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
147522: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

148384: WHEN 3 THEN 'CST_XLA_INV_REF_V'
148385: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'
148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'
148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'
148390: WHEN 9 THEN 'CST_XLA_INV_REF_V'
148391: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
148392: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

Line 148473: , PSA_CST_XLA_UPG_V h6

148469: , CST_XLA_INV_HEADERS_V h1
148470: , CST_XLA_INV_REF_V h3
148471: , PO_REQ_DISTS_REF_V h4
148472: , PO_REQ_HEADERS_REF_V h5
148473: , PSA_CST_XLA_UPG_V h6
148474: , fnd_lookup_values fvl12
148475: , fnd_lookup_values fvl38
148476: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
148477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

148761: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
148762: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
148764: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
148767: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
148768: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
148769: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 148855: , PSA_CST_XLA_UPG_V h6

148851: , CST_XLA_INV_HEADERS_V h1
148852: , CST_XLA_INV_REF_V h3
148853: , PO_REQ_DISTS_REF_V h4
148854: , PO_REQ_HEADERS_REF_V h5
148855: , PSA_CST_XLA_UPG_V h6
148856: , fnd_lookup_values fvl12
148857: , fnd_lookup_values fvl38
148858: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148859: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

151404: WHEN 3 THEN 'CST_XLA_INV_REF_V'
151405: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'
151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'
151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'
151410: WHEN 9 THEN 'CST_XLA_INV_REF_V'
151411: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
151412: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

Line 151493: , PSA_CST_XLA_UPG_V h6

151489: , CST_XLA_INV_HEADERS_V h1
151490: , CST_XLA_INV_REF_V h3
151491: , PO_REQ_DISTS_REF_V h4
151492: , PO_REQ_HEADERS_REF_V h5
151493: , PSA_CST_XLA_UPG_V h6
151494: , fnd_lookup_values fvl12
151495: , fnd_lookup_values fvl38
151496: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
151497: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

151781: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
151782: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
151784: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
151787: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
151788: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
151789: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 151875: , PSA_CST_XLA_UPG_V h6

151871: , CST_XLA_INV_HEADERS_V h1
151872: , CST_XLA_INV_REF_V h3
151873: , PO_REQ_DISTS_REF_V h4
151874: , PO_REQ_HEADERS_REF_V h5
151875: , PSA_CST_XLA_UPG_V h6
151876: , fnd_lookup_values fvl12
151877: , fnd_lookup_values fvl38
151878: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151879: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

155563: WHEN 3 THEN 'CST_XLA_INV_REF_V'
155564: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'
155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'
155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'
155569: WHEN 9 THEN 'CST_XLA_INV_REF_V'
155570: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
155571: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'

Line 155652: , PSA_CST_XLA_UPG_V h6

155648: , CST_XLA_INV_HEADERS_V h1
155649: , CST_XLA_INV_REF_V h3
155650: , PO_REQ_DISTS_REF_V h4
155651: , PO_REQ_HEADERS_REF_V h5
155652: , PSA_CST_XLA_UPG_V h6
155653: , fnd_lookup_values fvl12
155654: , fnd_lookup_values fvl38
155655: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
155656: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

155940: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
155941: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
155943: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
155946: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
155947: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
155948: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 156034: , PSA_CST_XLA_UPG_V h6

156030: , CST_XLA_INV_HEADERS_V h1
156031: , CST_XLA_INV_REF_V h3
156032: , PO_REQ_DISTS_REF_V h4
156033: , PO_REQ_HEADERS_REF_V h5
156034: , PSA_CST_XLA_UPG_V h6
156035: , fnd_lookup_values fvl12
156036: , fnd_lookup_values fvl38
156037: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156038: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 172441: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'

172437: WHEN 6 THEN 'PO_DISTS_REF_V'
172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'
172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'
172440: WHEN 9 THEN 'PO_HEADERS_REF_V'
172441: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
172442: WHEN 11 THEN 'CST_XLA_INV_REF_V'
172443: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
172444:
172445: ELSE null

Line 172523: , PSA_CST_XLA_UPG_V h6

172519: , CST_XLA_INV_HEADERS_V h1
172520: , CST_XLA_INV_REF_V h3
172521: , PO_DISTS_REF_V h4
172522: , PO_HEADERS_REF_V h5
172523: , PSA_CST_XLA_UPG_V h6
172524: , fnd_lookup_values fvl12
172525: , fnd_lookup_values fvl38
172526: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
172527: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 172818: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

172814: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
172815: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
172816: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
172817: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
172818: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
172819: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
172820: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
172821:
172822: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 172905: , PSA_CST_XLA_UPG_V h6

172901: , CST_XLA_INV_HEADERS_V h1
172902: , CST_XLA_INV_REF_V h3
172903: , PO_DISTS_REF_V h4
172904: , PO_HEADERS_REF_V h5
172905: , PSA_CST_XLA_UPG_V h6
172906: , fnd_lookup_values fvl12
172907: , fnd_lookup_values fvl38
172908: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
172909: and xet.event_class_code = C_EVENT_CLASS_CODE