APPS.PAY_US_MWR_REPORTING_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 176: from pay_assignment_actions paa -- SQWL assignment action

172: hr_utility.set_location(gv_package || '.range_code', 20);
173:
174: lv_sql_string :=
175: 'select distinct paa.assignment_id
176: from pay_assignment_actions paa -- SQWL assignment action
177: , pay_payroll_actions ppa
178: where ppa.business_group_id = ' || ln_business_group_id || '
179: and ppa.effective_date between to_date(''' || to_char(ld_start_date, 'dd-mon-yyyy') || ''', ''dd-mon-yyyy'') --Bug 3362257
180: and to_date(''' || to_char(ld_end_date, 'dd-mon-yyyy') || ''', ''dd-mon-yyyy'') --Bug 3362257

Line 214: from pay_assignment_actions paa -- SQWL assignment action

210: select paa.assignment_id,
211: ppa.effective_date,
212: paa.tax_unit_id,
213: paa.assignment_action_id
214: from pay_assignment_actions paa -- SQWL assignment action
215: , pay_payroll_actions ppa
216: where ppa.business_group_id = cp_business_group_id
217: and ppa.effective_date between cp_start_date
218: and cp_end_date

Line 271: select pay_assignment_actions_s.nextval

267: exit;
268: end if;
269:
270: hr_utility.set_location(gv_package || '.action_creation', 50);
271: select pay_assignment_actions_s.nextval
272: into ln_locking_action_id
273: from dual;
274:
275: -- **** CHECK FOR SUI WAGES HERE **** ----

Line 277: -- insert into pay_assignment_actions.

273: from dual;
274:
275: -- **** CHECK FOR SUI WAGES HERE **** ----
276:
277: -- insert into pay_assignment_actions.
278: hr_nonrun_asact.insact(ln_locking_action_id, ln_assignment_id,
279: p_payroll_action_id, p_chunk, ln_emp_tax_unit_id);
280: hr_utility.set_location(gv_package || '.action_creation', 60);
281:

Line 285: update pay_assignment_actions paa

281:
282: -- insert an interlock to this action
283: hr_nonrun_asact.insint(ln_locking_action_id, ln_assignment_action_id);
284:
285: update pay_assignment_actions paa
286: set paa.serial_number = ln_assignment_action_id
287: where paa.assignment_action_id = ln_locking_action_id;
288:
289: hr_utility.set_location(gv_package || '.action_creation', 60);

Line 308: pay_assignment_actions paa

304: ,paa.tax_unit_id
305: ,paa.serial_number
306: ,ppa.business_group_id
307: FROM pay_payroll_actions ppa,
308: pay_assignment_actions paa
309: WHERE ppa.payroll_action_id = p_payroll_action_id
310: AND ppa.payroll_action_id = paa.payroll_action_id;
311:
312: CURSOR c_asg_loc_mon ( p_ass_act_id number

Line 440: pay_assignment_actions paa,

436: select fai.value,
437: ppa.report_qualifier
438: from ff_archive_items fai,
439: ff_user_entities ue,
440: pay_assignment_actions paa,
441: pay_payroll_actions ppa
442: where fai.context1 = cp_sqwl_assact
443: and paa.assignment_action_id = fai.context1
444: and fai.user_entity_id = ue.user_entity_id

Line 652: FROM pay_assignment_actions paa,

648:
649: BEGIN
650: SELECT psr.jurisdiction_code
651: INTO l_sqwl_jurisdiction_code
652: FROM pay_assignment_actions paa,
653: pay_payroll_actions ppa,
654: pay_state_rules psr
655: WHERE paa.assignment_action_id = l_sqwl_assact
656: AND ppa.payroll_action_id = paa.payroll_action_id

Line 680: FROM pay_assignment_actions paa,

676: l_location_id := -99999;
677:
678: SELECT report_qualifier
679: INTO l_state_abbrev
680: FROM pay_assignment_actions paa,
681: pay_payroll_actions ppa
682: WHERE ppa.payroll_action_id = paa.payroll_action_id
683: AND paa.assignment_action_id = l_sqwl_assact;
684:

Line 745: FROM pay_assignment_actions paa,

741: -- Bug fix 5399921 START
742:
743: SELECT psr.jurisdiction_code
744: INTO l_sqwl_jurisdiction_code
745: FROM pay_assignment_actions paa,
746: pay_payroll_actions ppa,
747: pay_state_rules psr
748: WHERE paa.assignment_action_id = l_sqwl_assact
749: AND ppa.payroll_action_id = paa.payroll_action_id