APPS.PAY_ARCHIVE_MISSING_ASG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 85: pay_assignment_actions paa,

81:
82: SELECT distinct paf.assignment_id asg_id,
83: paa.assignment_action_id assact
84: FROM per_all_assignments_f paf,
85: pay_assignment_actions paa,
86: pay_payroll_actions ppa,
87: pay_payrolls_f ppf,
88: pay_us_asg_reporting puar
89: WHERE paf.assignment_id = paa.assignment_id

Line 107: pay_assignment_actions paa

103: AND paa.tax_unit_id = cp_tax_unit_id
104: AND paf.person_id between cp_start_person_id and cp_end_person_id
105: AND not exists (SELECT 1
106: FROM pay_payroll_actions ppa,
107: pay_assignment_actions paa
108: WHERE ppa.report_type = 'YREND'
109: AND ppa.action_status = 'C'
110: AND ppa.effective_date = cp_year_end
111: AND to_number(substr(legislative_parameters,

Line 133: pay_assignment_actions paa,

129:
130: SELECT distinct paf.assignment_id asg_id,
131: paa.assignment_action_id assact
132: FROM per_all_assignments_f paf,
133: pay_assignment_actions paa,
134: pay_payroll_actions ppa,
135: pay_payrolls_f ppf,
136: pay_us_asg_reporting puar,
137: pay_population_ranges ppr

Line 159: pay_assignment_actions paa

155: AND paa.tax_unit_id = cp_tax_unit_id
156: AND paf.person_id between cp_start_person_id and cp_end_person_id
157: AND not exists (SELECT 1
158: FROM pay_payroll_actions ppa,
159: pay_assignment_actions paa
160: WHERE ppa.report_type = 'YREND'
161: AND ppa.action_status = 'C'
162: AND ppa.effective_date = cp_year_end
163: AND to_number(substr(legislative_parameters,

Line 239: select pay_assignment_actions_s.nextval

235: hr_utility.trace('assignid = ' || assignid);
236: hr_utility.trace('lockedactid = ' || lockedactid);
237: END IF;
238:
239: select pay_assignment_actions_s.nextval
240: into lockingactid
241: from dual;
242:
243: l_step := 4;

Line 274: FROM pay_assignment_actions paa

270: Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER) IS
271:
272: CURSOR c_get_min_chunk is
273: SELECT min(paa.chunk_number)
274: FROM pay_assignment_actions paa
275: WHERE paa.payroll_action_id = p_payroll_action_id;
276:
277: -- Get Balance Attributes
278: CURSOR c_get_bal_attributes(cp_leg_code VARCHAR2

Line 387: pay_assignment_actions paa

383: WHERE EXISTS(
384: select 1
385: from pay_run_balances prb,
386: pay_balance_attributes pba,
387: pay_assignment_actions paa
388: where paa.assignment_id = cp_assignment_id
389: AND paa.tax_unit_id = cp_tax_unit_id
390: AND paa.tax_unit_id = prb.tax_unit_id
391: AND paa.assignment_Action_id = prb.assignment_Action_id

Line 405: pay_assignment_actions paa,

401: WHERE EXISTS (SELECT 1
402: FROM pay_run_results prr,
403: pay_run_result_values prrv,
404: pay_input_values_f piv,
405: pay_assignment_actions paa,
406: pay_payroll_actions ppa,
407: pay_payrolls_f ppf
408: WHERE paa.assignment_id = cp_assignment_id
409: AND paa.tax_unit_id = cp_tax_unit_id

Line 440: l_asgid pay_assignment_actions.assignment_id%TYPE;

436: FROM dual;
437:
438: lv_result_value number:=0;
439: lv_count number;
440: l_asgid pay_assignment_actions.assignment_id%TYPE;
441: l_chunk number;
442: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
443: lv_session_id number;
444: l_step number;