eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_RETRIEVAL_ROLLBACK dependencies on PAY_BATCH_LINES

Line 879: pay_batch_lines pbl

875: CURSOR get_details_backed_out(p_tim_id IN NUMBER,
876: p_batch_id IN NUMBER)
877: IS SELECT id
878: FROM hxt_det_hours_worked_f det,
879: pay_batch_lines pbl
880: WHERE tim_id = p_tim_id
881: AND pbl.batch_id = p_batch_id
882: AND pbl.batch_line_id = retro_pbl_line_id
883: AND pay_status = 'B';

Line 1278: FUNCTION reversed_line(p_lines PAY_BATCH_LINES%ROWTYPE)

1274: END IF;
1275: END reversal_batch_sequence;
1276:
1277:
1278: FUNCTION reversed_line(p_lines PAY_BATCH_LINES%ROWTYPE)
1279: RETURN pay_batch_lines%ROWTYPE
1280: IS
1281:
1282: CURSOR get_sequence(p_element_type_id IN NUMBER)

Line 1279: RETURN pay_batch_lines%ROWTYPE

1275: END reversal_batch_sequence;
1276:
1277:
1278: FUNCTION reversed_line(p_lines PAY_BATCH_LINES%ROWTYPE)
1279: RETURN pay_batch_lines%ROWTYPE
1280: IS
1281:
1282: CURSOR get_sequence(p_element_type_id IN NUMBER)
1283: IS SELECT display_sequence

Line 1290: l_out_lines pay_batch_lines%ROWTYPE;

1286: AND name = 'Hours';
1287:
1288:
1289: l_sequence NUMBER;
1290: l_out_lines pay_batch_lines%ROWTYPE;
1291:
1292: BEGIN
1293: IF NOT g_hours_iv_position.EXISTS(TO_CHAR(p_lines.element_type_id))
1294: THEN

Line 1438: FROM pay_batch_lines pbl,

1434:
1435: CURSOR get_lines
1436: IS SELECT batch_line_id,
1437: object_version_number
1438: FROM pay_batch_lines pbl,
1439: TABLE(return_ids(l_lines)) list
1440: WHERE list.column_value = pbl.batch_line_id;
1441: */
1442:

Line 1445: FROM pay_batch_lines

1441: */
1442:
1443: l_sql VARCHAR2(4000) :=
1444: 'SELECT *
1445: FROM pay_batch_lines
1446: WHERE batch_id = :1
1447: AND batch_line_id IN ';
1448:
1449: l_sql2 VARCHAR2(4000) :=

Line 1451: FROM pay_batch_lines

1447: AND batch_line_id IN ';
1448:
1449: l_sql2 VARCHAR2(4000) :=
1450: 'SELECT *
1451: FROM pay_batch_lines
1452: WHERE batch_line_id IN ';
1453:
1454: l_lines_list VARCHAR2(4000):= '(';
1455: l_lines_list2 VARCHAR2(4000) := '(';

Line 1457: TYPE LINESTAB IS TABLE OF pay_batch_lines%ROWTYPE;

1453:
1454: l_lines_list VARCHAR2(4000):= '(';
1455: l_lines_list2 VARCHAR2(4000) := '(';
1456:
1457: TYPE LINESTAB IS TABLE OF pay_batch_lines%ROWTYPE;
1458:
1459: l_status VARCHAR2(5);
1460: line_tab LINESTAB;
1461: ovn_tab NUMTAB;

Line 2005: pay_batch_lines pbl

2001: hxt_det_hours_worked_f det,
2002: hxc_ret_pay_latest_details ret,
2003: hxc_ret_pay_details ret2,
2004: FND_sessions sess,
2005: pay_batch_lines pbl
2006: WHERE sum.tim_id = p_tim_id
2007: AND sess.session_id = USERENV('sessionid')
2008: AND sess.effective_date BETWEEN sum.effective_start_date
2009: AND sum.effective_end_date

Line 2027: pay_batch_lines pbl,

2023: det.pbl_line_id,
2024: pbl.object_version_number
2025: FROM hxt_det_hours_worked_f det,
2026: hxt_sum_hours_worked_f sum,
2027: pay_batch_lines pbl,
2028: FND_Sessions sess
2029: WHERE sum.tim_id = p_tim_id
2030: AND sess.session_id = USERENV('sessionid')
2031: AND sess.effective_date BETWEEN sum.effective_start_date

Line 2403: FROM pay_batch_lines pbl,

2399: IS
2400:
2401: CURSOR get_timecards(p_batch_id IN NUMBER)
2402: IS SELECT DISTINCT tim_id
2403: FROM pay_batch_lines pbl,
2404: hxt_det_hours_worked_f det
2405: WHERE pbl.batch_id = p_batch_id
2406: AND ( pbl.batch_line_id = det.retro_pbl_line_id
2407: OR pbl.batch_id = det.retro_batch_id);

Line 2420: FROM pay_batch_lines pbl,

2416: IS SELECT DISTINCT
2417: ROWIDTOCHAR(det.ROWID),
2418: ROWIDTOCHAR(ret.ROWID),
2419: pbl.batch_line_id
2420: FROM pay_batch_lines pbl,
2421: hxt_det_hours_worked_f det,
2422: hxt_sum_hours_worked_f sum,
2423: hxc_ret_pay_latest_details ret
2424: WHERE pbl.batch_id = p_batch_id

Line 2444: FROM pay_batch_lines pbl,

2440: IS SELECT DISTINCT
2441: ROWIDTOCHAR(det.ROWID),
2442: ROWIDTOCHAR(ret.ROWID),
2443: pbl.batch_line_id
2444: FROM pay_batch_lines pbl,
2445: hxt_det_hours_worked_f det,
2446: hxt_sum_hours_worked_f sum,
2447: hxc_ret_pay_latest_details ret
2448: WHERE pbl.batch_id = p_batch_id

Line 2483: pay_batch_lines pbl

2479: pbl.batch_line_id
2480: FROM hxt_det_hours_worked_f det,
2481: hxt_sum_hours_worked_f sum,
2482: hxc_ret_pay_latest_details ret,
2483: pay_batch_lines pbl
2484: WHERE det.pay_status = 'C'
2485: AND det.retro_batch_id = p_batch_id
2486: AND det.retro_pbl_line_id = pbl.batch_line_id
2487: AND det.tim_id = p_tim_id

Line 2509: pay_batch_lines pbl

2505: ORDER BY det.ROWID) rank
2506: FROM hxt_det_hours_worked_f det,
2507: hxt_sum_hours_worked_f sum,
2508: hxc_ret_pay_latest_details ret,
2509: pay_batch_lines pbl
2510: WHERE det.pay_status = 'C'
2511: AND det.retro_batch_id = p_batch_id
2512: AND det.tim_id = p_tim_id
2513: AND det.retro_pbl_line_id = pbl.batch_line_id

Line 2539: FROM pay_batch_lines pbl,

2535: CURSOR get_backouts_not_in_ss(p_batch_id IN NUMBER,
2536: p_tim_id IN NUMBER)
2537: IS SELECT ROWIDTOCHAR(det.ROWID),
2538: pbl.batch_line_id
2539: FROM pay_batch_lines pbl,
2540: hxt_det_hours_worked_f det
2541: WHERE pbl.batch_id = p_batch_id
2542: AND pbl.batch_line_id = det.retro_pbl_line_id
2543: AND det.tim_id = p_tim_id

Line 2561: FROM pay_batch_lines pbl,

2557: CURSOR get_touched_not_in_ss(p_batch_id IN NUMBER,
2558: p_tim_id IN NUMBER)
2559: IS SELECT ROWIDTOCHAR(det.ROWID),
2560: pbl.batch_line_id
2561: FROM pay_batch_lines pbl,
2562: hxt_det_hours_worked_f det
2563: WHERE pbl.batch_id = p_batch_id
2564: AND pbl.batch_line_id = det.retro_pbl_line_id
2565: AND det.tim_id = p_tim_id