APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 50: token_val pay_payroll_actions.legislative_parameters%type;

46: parameter_list varchar2) return varchar2
47: is
48: start_ptr number;
49: end_ptr number;
50: token_val pay_payroll_actions.legislative_parameters%type;
51: par_value pay_payroll_actions.legislative_parameters%type;
52: begin
53:
54: token_val := name||'=';

Line 51: par_value pay_payroll_actions.legislative_parameters%type;

47: is
48: start_ptr number;
49: end_ptr number;
50: token_val pay_payroll_actions.legislative_parameters%type;
51: par_value pay_payroll_actions.legislative_parameters%type;
52: begin
53:
54: token_val := name||'=';
55:

Line 341: pay_payroll_actions ppa,

337: cp_tax_unit_id number) is
338: SELECT DISTINCT asg.assignment_id ass_id
339: FROM per_all_assignments_f asg,
340: pay_assignment_actions paa,
341: pay_payroll_actions ppa,
342: per_all_people_f ppf
343: WHERE ppa.effective_date BETWEEN cp_effective_date
344: AND add_months(cp_effective_date, 12) - 1
345: AND ppa.action_type in ('R','Q','V','B','I')

Line 356: FROM pay_payroll_actions ppa1,

352: AND asg.assignment_type = 'E'
353: AND ppa.effective_date between asg.effective_start_date AND asg.effective_end_date
354: AND ppa.effective_date between ppf.effective_start_date AND ppf.effective_end_date
355: AND NOT EXISTS ( SELECT 1
356: FROM pay_payroll_actions ppa1,
357: pay_assignment_actions paa1
358: WHERE ppa1.report_type = cp_report_type
359: AND ppa1.report_qualifier = 'CAEOY'
360: AND ppa1.effective_date = add_months(cp_effective_date, 12) - 1

Line 404: FROM pay_payroll_actions ppa,

400: and pac.context_id = fc.context_id
401: and fc.context_name = 'JURISDICTION_CODE'
402: and pac.context_value = 'QC')
403: AND NOT EXISTS (SELECT 1
404: FROM pay_payroll_actions ppa,
405: pay_assignment_actions paa
406: WHERE ppa.report_type = cp_report_type
407: AND ppa.report_qualifier = 'CAEOYRL1'
408: AND ppa.effective_date = add_months(cp_effective_date, 12) - 1

Line 444: FROM pay_payroll_actions ppa,

440: and pac.context_id = fc.context_id
441: and fc.context_name = 'JURISDICTION_CODE'
442: and pac.context_value = 'QC')
443: AND NOT EXISTS (SELECT 1
444: FROM pay_payroll_actions ppa,
445: pay_assignment_actions paa
446: WHERE ppa.report_type = cp_report_type
447: AND ppa.report_qualifier = 'CAEOYRL2'
448: AND ppa.effective_date = add_months(cp_effective_date, 12) - 1

Line 469: pay_payroll_actions ppa,

465: FROM pay_run_results prr,
466: pay_run_result_values prrv,
467: pay_input_values_f piv,
468: pay_assignment_actions paa,
469: pay_payroll_actions ppa,
470: pay_all_payrolls_f ppf
471: WHERE ppa.business_group_id+0 = cp_business_group
472: AND paa.assignment_id = cp_assignment_id
473: AND paa.tax_unit_id = cp_tax_unit_id