DBA Data[Home] [Help]

APPS.GMF_ALLOC_PROC dependencies on DUAL

Line 948: FROM dual;

944: )
945: IS
946: CURSOR cur_bal_type IS
947: SELECT decode(v_balance_type,'0','A','1','B','2','A')
948: FROM dual;
949:
950: CURSOR cur_currency IS
951: SELECT decode(v_balance_type,'0','STAT',NULL)
952: FROM dual;

Line 952: FROM dual;

948: FROM dual;
949:
950: CURSOR cur_currency IS
951: SELECT decode(v_balance_type,'0','STAT',NULL)
952: FROM dual;
953:
954: CURSOR Cur_get_ledgerinfo
955: (
956: p_ledger_id gl_period_statuses.ledger_id%TYPE

Line 1152: INTO l_new_x_to_segment FROM dual;

1148: ),
1149: X_segment_delimiter||X_segment_delimiter,
1150: X_segment_delimiter
1151: )
1152: INTO l_new_x_to_segment FROM dual;
1153: --End Bug 9241807
1154:
1155: **/
1156:

Line 1692: FROM dual

1688: USING ( SELECT g_period_id period_id,
1689: g_cost_type_id cost_type_id,
1690: cur_alocinp_tmp.alloc_id alloc_id,
1691: cur_alocinp_tmp.line_no line_no
1692: FROM dual
1693: ) ginp
1694: ON ( gdtl.period_id = ginp.period_id
1695: AND gdtl.cost_type_id = ginp.cost_type_id
1696: AND gdtl.alloc_id = ginp.alloc_id