APPS.JA_CN_HISDATA_MIG_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 559: FROM fnd_segment_attribute_values

555: ('CUSTOMER',
556: 'SUPPLIER',
557: 'EMPLOYEE_SUPPLIER',
558: (SELECT application_column_name
559: FROM fnd_segment_attribute_values
560: WHERE segment_attribute_type = 'FA_COST_CTR'
561: AND attribute_value = 'Y'
562: AND (id_flex_num = pn_chart_account_id)
563: AND (id_flex_code = 'GL#')

Line 584: FROM fnd_segment_attribute_values

580: 'pn_legal_entitliy_id=' || pn_legal_entitliy_id);
581:
582: SELECT application_column_name
583: INTO lv_costcenter_column
584: FROM fnd_segment_attribute_values
585: WHERE segment_attribute_type = 'FA_COST_CTR'
586: AND attribute_value = 'Y'
587: AND (id_flex_num = pn_chart_account_id)
588: AND (id_flex_code = 'GL#')

Line 633: FROM fnd_segment_attribute_values

629: WHERE (chart_of_accounts_id = pn_chart_account_id)
630: and context_code in
631: ('CUSTOMER', 'SUPPLIER', 'EMPLOYEE_SUPPLIER',
632: (SELECT application_column_name
633: FROM fnd_segment_attribute_values
634: WHERE segment_attribute_type = 'FA_COST_CTR'
635: AND attribute_value = 'Y'
636: AND (id_flex_num = pn_chart_account_id)
637: AND (id_flex_code = 'GL#')

Line 925: FROM fnd_segment_attribute_values

921: ('CUSTOMER',
922: 'SUPPLIER',
923: 'EMPLOYEE_SUPPLIER',
924: (SELECT application_column_name
925: FROM fnd_segment_attribute_values
926: WHERE segment_attribute_type = 'FA_COST_CTR'
927: AND attribute_value = 'Y'
928: AND (id_flex_num = P_COA_ID)
929: AND (id_flex_code = 'GL#')

Line 1252: FROM fnd_segment_attribute_values

1248: ('CUSTOMER',
1249: 'SUPPLIER',
1250: 'EMPLOYEE_SUPPLIER',
1251: (SELECT application_column_name
1252: FROM fnd_segment_attribute_values
1253: WHERE segment_attribute_type = 'FA_COST_CTR'
1254: AND attribute_value = 'Y'
1255: AND (id_flex_num = P_COA_ID)
1256: AND (id_flex_code = 'GL#')

Line 1302: FROM fnd_segment_attribute_values

1298: WHERE sam.sources_code = 'COA'
1299: AND sam.chart_of_accounts_id = P_COA_ID
1300: AND sam.context_code IN
1301: (SELECT application_column_name
1302: FROM fnd_segment_attribute_values
1303: WHERE attribute_value = 'Y'
1304: AND (id_flex_num = P_COA_ID)
1305: AND (id_flex_code = 'GL#')
1306: AND (application_id = 101)

Line 1309: FROM fnd_segment_attribute_values

1305: AND (id_flex_code = 'GL#')
1306: AND (application_id = 101)
1307: AND application_column_name NOT IN
1308: (SELECT application_column_name
1309: FROM fnd_segment_attribute_values
1310: WHERE attribute_value = 'Y'
1311: AND (id_flex_num = P_COA_ID)
1312: AND (id_flex_code = 'GL#')
1313: AND (application_id = 101)

Line 1571: FROM fnd_segment_attribute_values

1567: ('CUSTOMER',
1568: 'SUPPLIER',
1569: 'EMPLOYEE_SUPPLIER',
1570: (SELECT application_column_name
1571: FROM fnd_segment_attribute_values
1572: WHERE segment_attribute_type = 'FA_COST_CTR'
1573: AND attribute_value = 'Y'
1574: AND (id_flex_num = pn_chart_account_id)
1575: AND (id_flex_code = 'GL#')

Line 1596: FROM fnd_segment_attribute_values

1592: 'pn_legal_entitliy_id=' || pn_legal_entitliy_id);
1593:
1594: SELECT application_column_name
1595: INTO lv_costcenter_column
1596: FROM fnd_segment_attribute_values
1597: WHERE segment_attribute_type = 'FA_COST_CTR'
1598: AND attribute_value = 'Y'
1599: AND (id_flex_num = pn_chart_account_id)
1600: AND (id_flex_code = 'GL#')