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_SA_HIST_ARCH_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 128: pay_assignment_actions paa,

124: paaf.assignment_id,
125: ppa.effective_date
126: from per_all_assignments_f paaf,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1
132: where paa.SOURCE_ACTION_ID is null

Line 131: pay_assignment_actions paa1

127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1
132: where paa.SOURCE_ACTION_ID is null
133: and paaf.person_id between stperson and endperson
134: and ppa.report_type = 'SA_ARCHIVE'
135: and ppa.action_type ='X'

Line 187: select pay_assignment_actions_s.nextval

183: hr_utility.set_location('endperson :' ||endperson ,10);
184:
185: for asgrec in get_arch_action_det(l_payroll_id,l_bg_id,l_start_date,l_end_date)
186: loop
187: select pay_assignment_actions_s.nextval
188: into lockingactid
189: from dual;
190:
191: hr_nonrun_asact.insact

Line 237: ,pay_assignment_actions prepay_assact

233: SELECT run_assact.assignment_id run_assgt_id
234: ,run_assact.assignment_action_id run_assact_id
235: ,prepay_payact.effective_date prepay_effective_date
236: FROM pay_action_interlocks archive_intlck
237: ,pay_assignment_actions prepay_assact
238: ,pay_payroll_actions prepay_payact
239: ,pay_action_interlocks prepay_intlck
240: ,pay_assignment_actions run_assact
241: ,pay_payroll_actions run_payact

Line 240: ,pay_assignment_actions run_assact

236: FROM pay_action_interlocks archive_intlck
237: ,pay_assignment_actions prepay_assact
238: ,pay_payroll_actions prepay_payact
239: ,pay_action_interlocks prepay_intlck
240: ,pay_assignment_actions run_assact
241: ,pay_payroll_actions run_payact
242: WHERE archive_intlck.locking_action_id = p_locking_action_id
243: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
244: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 254: FROM pay_assignment_actions

250: ORDER BY prepay_intlck.locking_action_id,prepay_intlck.locked_action_id desc;
251:
252: CURSOR get_prl_actid (p_assignment_action_id NUMBER) IS
253: SELECT payroll_action_id
254: FROM pay_assignment_actions
255: WHERE assignment_Action_id = p_assignment_action_id;
256:
257: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
258: l_run_asg_action_id pay_assignment_actions.assignment_action_id%type;

Line 257: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

253: SELECT payroll_action_id
254: FROM pay_assignment_actions
255: WHERE assignment_Action_id = p_assignment_action_id;
256:
257: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
258: l_run_asg_action_id pay_assignment_actions.assignment_action_id%type;
259: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
260: l_assignment_id number;
261: l_effective_date date;

Line 258: l_run_asg_action_id pay_assignment_actions.assignment_action_id%type;

254: FROM pay_assignment_actions
255: WHERE assignment_Action_id = p_assignment_action_id;
256:
257: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
258: l_run_asg_action_id pay_assignment_actions.assignment_action_id%type;
259: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
260: l_assignment_id number;
261: l_effective_date date;
262: