APPS.HXT_TIME_PAY dependencies on HXT_SEQNO

Line 400: SELECT hxt_seqno.nextval next_id

396: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
397: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
398:
399: CURSOR next_id_cur IS
400: SELECT hxt_seqno.nextval next_id
401: FROM dual;
402:
403: l_id NUMBER;
404: l_pay_status CHAR(1);

Line 1703: (hxt_seqno.nextval, g_ID, g_TIM_ID,

1699: RETRO_BATCH_ID
1700: --GROUP_ID
1701: )
1702: VALUES
1703: (hxt_seqno.nextval, g_ID, g_TIM_ID,
1704: g_DATE_WORKED, g_ASSIGNMENT_ID,
1705: l_hours, -- SIR092
1706: p_time_in, p_time_out,
1707: elig_prem_rec.elt_premium_id, '',

Line 1737: SELECT hxt_seqno.nextval,

1733:
1734:
1735: /* Call dml to insert hours */
1736:
1737: SELECT hxt_seqno.nextval,
1738: decode(elig_prem_rec.hxt_premium_type, 'FACTOR',
1739: NVL(g_RATE_MULTIPLE, elig_prem_rec.hxt_premium_amount),
1740: g_RATE_MULTIPLE),
1741: decode(elig_prem_rec.hxt_premium_type, 'RATE', NVL(g_HOURLY_RATE,