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.PAY_HK_IR56_MAGTAPE dependencies on PER_ALL_PEOPLE_F

Line 22: ** 29 MAY 2003 KAVERMA 2920731 Replaced tables per_all_assignments_f and per_all_people_f

18: ** of the procedure 'range_code'
19: ** 11 MAR 2003 SRRAJAGO 2829320 In the process_assignments cursor, included the join
20: ** paa.action_status = 'C' to prevent magtape fetching
21: ** the errored archive records.
22: ** 29 MAY 2003 KAVERMA 2920731 Replaced tables per_all_assignments_f and per_all_people_f
23: ** by secured views per_assignments_f and per_people_f from queries.
24: ** 28 AUG 2008 JALIN 7324233 In the process_assignments cursor,it should
25: ** lock the assignments which has magtape
26: ** generatedi, it should not lock with archive

Line 58: p_start_person_id in per_all_people_f.person_id%TYPE,

54: **********************************************************/
55:
56: PROCEDURE assignment_action_code
57: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
58: p_start_person_id in per_all_people_f.person_id%TYPE,
59: p_end_person_id in per_all_people_f.person_id%TYPE,
60: p_chunk in number)
61: IS
62: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 59: p_end_person_id in per_all_people_f.person_id%TYPE,

55:
56: PROCEDURE assignment_action_code
57: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
58: p_start_person_id in per_all_people_f.person_id%TYPE,
59: p_end_person_id in per_all_people_f.person_id%TYPE,
60: p_chunk in number)
61: IS
62: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
63: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 97: c_start_person_id in per_all_people_f.person_id%TYPE,

93:
94: --------------------
95: CURSOR process_assignments
96: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
97: c_start_person_id in per_all_people_f.person_id%TYPE,
98: c_end_person_id in per_all_people_f.person_id%TYPE)
99:
100: IS
101:

Line 98: c_end_person_id in per_all_people_f.person_id%TYPE)

94: --------------------
95: CURSOR process_assignments
96: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
97: c_start_person_id in per_all_people_f.person_id%TYPE,
98: c_end_person_id in per_all_people_f.person_id%TYPE)
99:
100: IS
101:
102: select distinct paaf.assignment_id,