APPS.AMS_PARTY_SEG_LOADER_PVT dependencies on AMS_ACT_SIZES

Line 544: from ams_act_sizes

540:
541: CURSOR c_last_size (p_cell_id IN number)
542: IS
543: select act_size
544: from ams_act_sizes
545: where arc_act_size_used_by = 'CELL'
546: and act_size_used_by_id = p_cell_id
547: order by last_update_date desc, activity_size_id desc;
548:

Line 652: INSERT INTO ams_act_sizes

648: IF l_last_size is null THEN
649: l_last_size := 0;
650: END IF;
651:
652: INSERT INTO ams_act_sizes
653: (
654: activity_size_id,
655: last_update_date,
656: last_updated_by,

Line 668: ams_act_sizes_s.nextval,

664: size_delta
665: )
666: VALUES
667: (
668: ams_act_sizes_s.nextval,
669: SYSDATE,
670: fnd_global.user_id,
671: SYSDATE,
672: fnd_global.user_id,