APPS.PAY_MX_ANNUAL_WRI dependencies on PAY_PAYROLL_ACTIONS

Line 120: FROM pay_payroll_actions ppa_mag

116: SELECT pay_mx_utility.get_legi_param_val('GRE',
117: ppa_mag.legislative_parameters),
118: fnd_date.date_to_canonical (start_date),
119: fnd_date.date_to_canonical (effective_date)
120: FROM pay_payroll_actions ppa_mag
121: WHERE ppa_mag.payroll_action_id = p_payroll_action_id;
122:
123: l_proc_name varchar2(100);
124: BEGIN

Line 164: pay_payroll_actions ppa_sua,

160:
161: p_sqlstr := '
162: SELECT DISTINCT paf.person_id
163: FROM per_assignments_f paf,
164: pay_payroll_actions ppa_sua,
165: pay_assignment_actions paa_sua
166: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
167: AND paa_sua.assignment_id = paf.assignment_id
168: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val

Line 212: pay_payroll_actions ppa_sua,

208: paa_sua.assignment_action_id,
209: paf.primary_flag,
210: paf.effective_end_date
211: FROM per_assignments_f paf,
212: pay_payroll_actions ppa_sua,
213: pay_assignment_actions paa_sua,
214: pay_action_interlocks lck,
215: pay_action_information pai
216: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id

Line 255: pay_payroll_actions ppa_sua,

251: paa_sua.assignment_action_id,
252: paf.primary_flag,
253: paf.effective_end_date
254: FROM per_assignments_f paf,
255: pay_payroll_actions ppa_sua,
256: pay_assignment_actions paa_sua,
257: pay_action_interlocks lck,
258: pay_action_information pai,
259: pay_population_ranges ppr

Line 445: pay_payroll_actions ppa,

441: CURSOR csr_person_info (cp_person_id number) IS
442: SELECT pai.action_information_id
443: FROM pay_action_information pai,
444: pay_assignment_actions paa,
445: pay_payroll_actions ppa,
446: pay_action_interlocks lck,
447: pay_assignment_actions paa_arch,
448: pay_payroll_actions ppa_arch
449: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 448: pay_payroll_actions ppa_arch

444: pay_assignment_actions paa,
445: pay_payroll_actions ppa,
446: pay_action_interlocks lck,
447: pay_assignment_actions paa_arch,
448: pay_payroll_actions ppa_arch
449: WHERE paa.payroll_action_id = ppa.payroll_action_id
450: AND fnd_number.canonical_to_number(
451: pay_mx_utility.get_legi_param_val('GRE',
452: ppa.legislative_parameters)) = g_gre_id

Line 481: pay_payroll_actions ppa_arch,

477: /*SELECT pai.action_information_id
478: FROM pay_action_information pai,
479: pay_action_interlocks lck_sua,
480: pay_action_interlocks lck_arch,
481: pay_payroll_actions ppa_arch,
482: pay_assignment_actions paa_arch
483: WHERE lck_sua.locking_action_id = cp_wri_asg_act
484: AND lck_sua.locked_action_id = lck_arch.locking_action_id
485: AND lck_arch.locked_action_id = pai.action_context_id