[Home] [Help]
483: pay_assignment_actions paa1 ,
484: pay_payroll_actions ppa ,
485: pay_run_results prr ,
486: pay_element_types_f pet ,
487: pay_element_classifications pec
488: where paa.assignment_action_id = cp_assignment_action_id
489: and paa1.assignment_id = paa.assignment_id
490: -- and paa1.source_action_id is not null --for bug 5332346
491: and ppa.payroll_action_id = paa1.payroll_action_id
529: pet.processing_priority
530: from pay_element_entries_f pee,
531: pay_run_results prr,
532: pay_element_types_f pet,
533: pay_element_classifications pec
534: where pee.assignment_id = cp_assignment_id
535: --and pee.effective_end_date >= trunc(cp_date_earned, 'Y')
536: and pee.effective_start_date <= cp_date_earned
537: and prr.source_id = pee.element_entry_id
584: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
585: l_date_earned pay_payroll_actions.date_earned%type;
586: l_date_paid pay_payroll_actions.effective_date%type;
587: l_business_group_id pay_element_types_f.business_group_id%type;
588: l_classification_name pay_element_classifications.classification_name%type;
589: l_processing_priority pay_element_types_f.processing_priority%type;
590:
591:
592: -- Procedure to get the position of the reporting name in the plsql table
2672: pay_assignment_actions paa1 ,
2673: pay_payroll_actions ppa ,
2674: pay_run_results prr ,
2675: pay_element_types_f pet ,
2676: pay_element_classifications pec
2677: where paa.assignment_action_id = cp_assignment_action_id
2678: and paa1.assignment_id = paa.assignment_id
2679: -- and paa1.source_action_id is not null --for bug 5332346
2680: and ppa.payroll_action_id = paa1.payroll_action_id
2702: pet.processing_priority
2703: from pay_element_entries_f pee,
2704: pay_run_results prr,
2705: pay_element_types_f pet,
2706: pay_element_classifications pec
2707: where pee.assignment_id = cp_assignment_id
2708: and pee.effective_end_date >= trunc(cp_date_earned, 'Y')
2709: and pee.effective_start_date <= cp_date_earned
2710: and prr.source_id = pee.element_entry_id