APPS.PAY_ARCH_MISSING_ASG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 116: FROM pay_assignment_actions paa

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

Line 263: pay_assignment_actions paa,

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

Line 290: pay_assignment_actions paa,

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

Line 320: SELECT pay_assignment_actions_s.nextval

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

Line 352: FROM pay_assignment_actions paa

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

Line 477: l_asgid pay_assignment_actions.assignment_id%TYPE;

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

Line 560: pay_assignment_actions paa

556: WHERE EXISTS(
557: select 1
558: from pay_run_balances prb,
559: pay_balance_attributes pba,
560: pay_assignment_actions paa
561: where paa.assignment_id = '||to_char(l_asgid)||'
562: AND paa.assignment_Action_id = prb.assignment_Action_id
563: AND prb.effective_date between '''||to_char(add_months(g_effective_date,-12)+1)||
564: ''' and '''||to_char(g_effective_date)||'''

Line 591: pay_assignment_actions paa,

587: WHERE EXISTS (SELECT 1
588: FROM pay_run_results prr,
589: pay_run_result_values prrv,
590: pay_input_values_f piv,
591: pay_assignment_actions paa,
592: pay_payroll_actions ppa,
593: pay_payrolls_f ppf
594: WHERE paa.assignment_id = '||to_char(l_asgid)||'
595: AND prr.assignment_Action_id = paa.assignment_Action_id