DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PS_SCHD_HDR

Line 524: FROM ps_schd_hdr

520: Procedure ps_data_retrieval (V_item_id IN NUMBER, V_organization_id IN NUMBER) IS
521:
522: CURSOR get_order_ind_cur IS
523: SELECT order_ind
524: FROM ps_schd_hdr
525: WHERE schedule_id = G_schedule_id;
526:
527: CURSOR Cur_fpo_doc_no IS
528: SELECT batch_no

Line 1382: FROM ps_schd_hdr

1378: l_non_nettable NUMBER;
1379:
1380: Cursor Cur_nettable_ind ( V_schedule_id NUMBER) IS
1381: SELECT NVL(nonnet_ind,0)
1382: FROM ps_schd_hdr
1383: WHERE schedule_id = V_schedule_id;
1384:
1385: BEGIN
1386:

Line 1868: FROM ps_schd_hdr

1864: v_schedule_name VARCHAR2(16);
1865: BEGIN
1866:
1867: SELECT schedule INTO v_schedule_name
1868: FROM ps_schd_hdr
1869: WHERE schedule_id = p_schedule_id;
1870:
1871: RETURN v_schedule_name;
1872: