DBA Data[Home] [Help]

APPS.PA_DDC_API dependencies on PA_STATUS_COLUMN_SETUP

Line 11: FROM pa_status_column_setup

7: dummy NUMBER := 0;
8: BEGIN
9: SELECT count(1)
10: INTO dummy
11: FROM pa_status_column_setup
12: WHERE folder_code = x_folder_code
13: AND INSTR(column_name,x_alias) > 0;
14:
15: IF (dummy >= 1) THEN

Line 42: FROM pa_status_column_setup

38:
39:
40: CURSOR p1 IS
41: SELECT format_code, column_name, currency_format_flag
42: FROM pa_status_column_setup
43: WHERE folder_code = 'P'
44: order by folder_code, format_code, column_order;
45:
46: CURSOR t1 IS

Line 48: FROM pa_status_column_setup

44: order by folder_code, format_code, column_order;
45:
46: CURSOR t1 IS
47: SELECT format_code, column_name, currency_format_flag
48: FROM pa_status_column_setup
49: WHERE folder_code = 'T'
50: order by folder_code, format_code, column_order;
51:
52: CURSOR r1 IS

Line 54: FROM pa_status_column_setup

50: order by folder_code, format_code, column_order;
51:
52: CURSOR r1 IS
53: SELECT format_code, column_name, currency_format_flag
54: FROM pa_status_column_setup
55: WHERE folder_code = 'R'
56: order by folder_code, format_code, column_order;
57:
58: