APPS.PSB_GL_INTERFACE_PVT dependencies on DUAL

Line 54: dual_posting_type VARCHAR2(1));

50:
51: TYPE HdrArrayRec IS RECORD
52: (ae_header_id NUMBER,
53: budget_version_id NUMBER,
54: dual_posting_type VARCHAR2(1));
55:
56: TYPE HdrArrayTbl IS TABLE OF HdrArrayRec
57: INDEX BY BINARY_INTEGER;
58:

Line 1078: FROM dual;

1074:
1075: CURSOR l_packet_csr
1076: IS
1077: SELECT gl_bc_packets_s.nextval
1078: FROM dual;
1079: PRAGMA autonomous_transaction;
1080:
1081: /* 5148282 made this api as autonomous transaction
1082: as funds check runs as a separate transaction */

Line 1298: FROM dual;

1294:
1295: CURSOR l_packet_csr
1296: IS
1297: SELECT gl_bc_packets_s.nextval
1298: FROM dual;
1299:
1300: l_packetid GL_bc_packets.packet_id%TYPE;
1301:
1302: BEGIN

Line 1492: FROM dual;

1488: SELECT gl_interface_control_s.NEXTVAL,
1489: gl_journal_import_s.NEXTVAL
1490: INTO l_group_id,
1491: l_interface_run_id
1492: FROM dual;
1493:
1494: INSERT INTO gl_interface_control
1495: (JE_SOURCE_NAME,
1496: STATUS,

Line 2237: p_dual_posting_type => l_budget_version_flag,

2233: p_msg_data => l_msg_data,
2234: p_gl_budget_set_id => p_gl_budget_set_id,
2235: p_code_combination_id => c_detail_rec.code_combination_id,
2236: p_start_date => p_gl_period_start,
2237: p_dual_posting_type => l_budget_version_flag,
2238: p_gl_budget_version_id => l_budget_version_id
2239: );
2240:
2241: IF l_budget_version_id IS NULL THEN

Line 2383: p_dual_posting_type => l_budget_version_flag,

2379: p_msg_data => l_msg_data,
2380: p_gl_budget_set_id => p_gl_budget_set_id,
2381: p_code_combination_id => c_summary_rec.code_combination_id,
2382: p_start_date => p_gl_period_start,
2383: p_dual_posting_type => l_budget_version_flag,
2384: p_gl_budget_version_id => l_budget_version_id
2385: );
2386:
2387: IF l_budget_version_id IS NULL THEN

Line 2741: FROM dual

2737:
2738: CURSOR c_post_to_all
2739: IS
2740: SELECT 'Y'
2741: FROM dual
2742: WHERE EXISTS
2743: (SELECT 1
2744: FROM psb_GL_BUDGETS
2745: WHERE dual_posting_type = 'A'

Line 2745: WHERE dual_posting_type = 'A'

2741: FROM dual
2742: WHERE EXISTS
2743: (SELECT 1
2744: FROM psb_GL_BUDGETS
2745: WHERE dual_posting_type = 'A'
2746: AND gl_budget_set_id = p_gl_budget_set_id
2747: AND start_date BETWEEN l_year_start_date AND l_year_end_date
2748: );
2749:

Line 3267: 'AND NVL(dual_posting_type, ''P'') = DECODE(:permanent_revision, ''Y'', NVL(dual_posting_type, ''P''), ''A'') ' ||

3263: 'WHERE :start_date BETWEEN vgb.start_date AND vgb.end_date ' ||
3264: 'AND vgb.gl_budget_set_id = :gl_budget_set_id ' ||
3265: 'AND vgb.gl_budget_id = vs.gl_budget_id ' ||
3266: 'AND vs.account_position_set_id = v.account_position_set_id ' ||
3267: 'AND NVL(dual_posting_type, ''P'') = DECODE(:permanent_revision, ''Y'', NVL(dual_posting_type, ''P''), ''A'') ' ||
3268: /* Bug No 1357416 Start */
3269: 'AND v.code_combination_id = bra.code_combination_id)'
3270: /* Bug No 1357416 END */
3271: USING p_source_id, p_start_date, p_gl_budget_set_id, g_permanent_revision;