APPS.PAY_ARCH_MISSING_ASG_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 80: from pay_payroll_actions ppa

76:
77: select ppa.legislative_parameters,
78: ppa.business_group_id
79: into lv_legislative_param, ln_business_group_id
80: from pay_payroll_actions ppa
81: where payroll_action_id = pactid;
82:
83: hr_utility.set_location(l_proc, 20);
84:

Line 107: pay_payroll_actions PPA

103: hr_utility.set_location(l_proc, 60);
104:
105: sqlstr := 'SELECT distinct ASG.person_id
106: FROM per_all_assignments_f ASG,
107: pay_payroll_actions PPA
108: WHERE PPA.payroll_action_id = :payroll_action_id
109: AND ASG.business_group_id = PPA.business_group_id
110: AND ASG.payroll_id is not null
111: AND ASG.assignment_type = ''E''

Line 202: FROM pay_payroll_actions

198: ln_business_group_id,
199: lv_report_type,
200: lv_report_qualifier,
201: lv_report_category
202: FROM pay_payroll_actions
203: WHERE payroll_action_id = pactid;
204:
205:
206: hr_utility.trace('g_effective_date:'|| to_char(g_effective_date,'dd-mm-yyyy'));

Line 264: pay_payroll_actions ppa,

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
268: AND paf.assignment_type = ''E''

Line 291: pay_payroll_actions ppa,

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''
295: AND paf.effective_start_date <= add_months(ppa.effective_date, 12) - 1

Line 408: FROM pay_payroll_actions ppa

404: INTO l_param,
405: l_business_group_id,
406: l_start_date,
407: l_end_date
408: FROM pay_payroll_actions ppa
409: WHERE ppa.payroll_action_id = p_payroll_action_id;
410:
411: l_step := 2;
412: OPEN c_get_leg_code(l_business_group_id);

Line 479: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

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;
482: l_proc VARCHAR2(240);
483: lv_ac_where VARCHAR2(10000);

Line 520: from pay_payroll_actions ppa

516: close c_get_session_id;
517:
518: select ppa.business_group_id
519: into ln_business_group_id
520: from pay_payroll_actions ppa
521: where payroll_action_id = l_payroll_action_id;
522:
523: hr_utility.set_location(l_proc, 20);
524:

Line 592: pay_payroll_actions ppa,

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
596: AND ppa.payroll_action_id = paa.payroll_action_id

Line 681: from pay_payroll_actions

677: pay_core_utils.get_parameter('TRANSFER_GRE',
678: legislative_parameters)
679: into g_effective_date,
680: g_tax_unit_id
681: from pay_payroll_actions
682: where payroll_action_id = p_payroll_action_id;
683: --
684: hr_utility.trace('g_effective_date ='||g_effective_date);
685: hr_utility.trace('g_tax_unit_id ='||g_tax_unit_id);