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

Line 119: FROM pay_assignment_actions paa

115: AND ASG.effective_start_date <= PPA.effective_date
116: AND ASG.effective_end_date >= PPA.start_date
117: AND EXISTS ( --CHECKING THAT ATLEAST ONE ASSIGN ACT EXIST
118: SELECT 1
119: FROM pay_assignment_actions paa
120: WHERE paa.assignment_id = ASG.assignment_id
121: AND PAA.action_status = ''C'''
122: ||lv_rc_where||
123: ')

Line 266: pay_assignment_actions paa,

262: c_actions_sql :=
263: 'SELECT distinct paf.assignment_id asg_id,
264: paa.assignment_action_id assact
265: FROM per_all_assignments_f paf,
266: pay_assignment_actions paa,
267: pay_payroll_actions ppa,
268: pay_payrolls_f ppf,
269: pay_population_ranges ppr
270: WHERE paf.assignment_id = paa.assignment_id

Line 293: pay_assignment_actions paa,

289: c_actions_sql :=
290: 'SELECT distinct paf.assignment_id asg_id,
291: paa.assignment_action_id assact
292: FROM per_all_assignments_f paf,
293: pay_assignment_actions paa,
294: pay_payroll_actions ppa,
295: pay_payrolls_f ppf
296: WHERE paf.assignment_id = paa.assignment_id
297: AND paf.assignment_type = ''E''

Line 323: SELECT pay_assignment_actions_s.nextval

319: hr_utility.trace('assignid = ' || assignid);
320: hr_utility.trace('lockedactid = ' || lockedactid);
321:
322:
323: SELECT pay_assignment_actions_s.nextval
324: INTO lockingactid
325: FROM dual;
326:
327: l_step := 5;

Line 355: FROM pay_assignment_actions paa

351: Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER) IS
352:
353: CURSOR c_get_min_chunk is
354: SELECT min(paa.chunk_number)
355: FROM pay_assignment_actions paa
356: WHERE paa.payroll_action_id = p_payroll_action_id;
357:
358: -- Get Balance Attributes
359: CURSOR c_get_bal_attributes(cp_leg_code VARCHAR2

Line 480: l_asgid pay_assignment_actions.assignment_id%TYPE;

476: WHERE business_group_id = cp_business_group_id;
477:
478: lv_result_value number:=0;
479: lv_count number;
480: l_asgid pay_assignment_actions.assignment_id%TYPE;
481: l_chunk number;
482: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
483: lv_session_id number;
484: l_step number;

Line 563: pay_assignment_actions paa,

559: WHERE EXISTS(
560: select 1
561: from pay_run_balances prb,
562: pay_balance_attributes pba,
563: pay_assignment_actions paa,
564: pay_payroll_actions ppa
565: where paa.assignment_id = '||to_char(l_asgid)||'
566: AND paa.payroll_action_id = ppa.payroll_action_id
567: AND paa.assignment_Action_id = prb.assignment_Action_id

Line 596: pay_assignment_actions paa,

592: WHERE EXISTS (SELECT 1
593: FROM pay_run_results prr,
594: pay_run_result_values prrv,
595: pay_input_values_f piv,
596: pay_assignment_actions paa,
597: pay_payroll_actions ppa,
598: pay_payrolls_f ppf
599: WHERE paa.assignment_id = '||to_char(l_asgid)||'
600: AND prr.assignment_Action_id = paa.assignment_Action_id