DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PS_SCHD_HDR

Line 526: FROM ps_schd_hdr

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

Line 1388: FROM ps_schd_hdr

1384: l_non_nettable NUMBER;
1385:
1386: Cursor Cur_nettable_ind ( V_schedule_id NUMBER) IS
1387: SELECT NVL(nonnet_ind,0)
1388: FROM ps_schd_hdr
1389: WHERE schedule_id = V_schedule_id;
1390:
1391: BEGIN
1392:

Line 1930: FROM ps_schd_hdr

1926: v_schedule_name VARCHAR2(16);
1927: BEGIN
1928:
1929: SELECT schedule INTO v_schedule_name
1930: FROM ps_schd_hdr
1931: WHERE schedule_id = p_schedule_id;
1932:
1933: RETURN v_schedule_name;
1934: