[Home] [Help]
123: SELECT MAX(paa.assignment_action_id)
124: FROM per_assignments_f paf,
125: pay_assignment_actions paa,
126: pay_payroll_actions ppa,
127: per_time_periods ptp
128: WHERE paf.person_id = l_person_id
129: AND paf.assignment_id = paa.assignment_id
130: AND paa.action_status IN ('C','S') --10225372
131: AND ppa.payroll_action_id = paa.payroll_action_id
247: FROM per_people_f per,
248: per_assignments_f asg,
249: pay_assignment_actions paa,
250: pay_payroll_actions ppa,
251: per_time_periods ptp,
252: pay_run_results prr,
253: pay_element_types_f pet,
254: pay_input_values_f piv1,
255: pay_run_result_values rrv1
808: FROM per_assignments_f asg,
809: pay_assignment_actions paa,
810: pay_payroll_actions ppa,
811: pay_all_payrolls_f pap,
812: per_time_periods ptp,
813: hr_soft_coding_keyflex flex
814: WHERE paa.source_action_id IS NULL
815: AND paa.payroll_action_id = ppa.payroll_action_id
816: --Added for date track updates of payroll with diff pay ref no
836: (SELECT MAX (paf.effective_end_date)
837: FROM per_assignments_f paf,
838: pay_assignment_actions paa1, --Bug fix 4130665
839: pay_payroll_actions ppa1,
840: per_time_periods ptp1 --Tar 15081088.6
841: ,pay_all_payrolls_f pay
842: ,hr_soft_coding_keyflex flex1
843: WHERE paf.person_id = asg.person_id
844: -- AND paf.primary_flag = 'Y'
1767: pay_action_information pact_ad,
1768: per_assignments_f paf,
1769: per_periods_of_service pps,
1770: -- pay_ie_paye_details_f payef,
1771: per_time_periods ptp,
1772: per_people_f ppf
1773: WHERE pact_iedi.action_information_category = 'IE EMPLOYEE DETAILS'
1774: AND pact_iedi.action_context_type = 'AAP'
1775: AND pact_iedi.action_context_id = p_locked_action
2323: 0) --Bug 4111753
2324: /*( NVL(paye.weekly_tax_credit,0) +
2325: NVL(paye.Monthly_tax_credit,0)) * ptp.period_num */
2326: FROM per_assignments_f paf,
2327: per_time_periods ptp,
2328: pay_ie_paye_details_f paye
2329: WHERE paf.assignment_id = p_assignment_id
2330: AND paye.assignment_id=paf.assignment_id
2331: AND p_term_date between paf.effective_start_date
2423: CURSOR c_get_max_aact(p_pds_id NUMBER) IS
2424: SELECT max(paa.assignment_action_id)
2425: FROM pay_assignment_Actions paa,
2426: pay_payroll_actions ppa
2427: -- ,per_time_periods ptp -- removed to improve performance 4771780
2428: WHERE paa.assignment_id in (SELECT assignment_id
2429: FROM per_assignments_f
2430: WHERE period_of_service_id = p_pds_id)
2431: AND paa.payroll_action_id = ppa.payroll_action_id
7738: FROM per_people_f ppf,
7739: per_assignments_f paf,
7740: pay_assignment_actions paa,
7741: pay_payroll_actions ppa,
7742: per_time_periods ptp
7743: WHERE
7744: ppf.person_id = p_person_id
7745: AND paf.assignment_id = p_assignment_id -- vik added code for getting values for given assignment
7746: AND ppf.current_employee_flag = 'Y'
7784: FROM per_people_f per,
7785: per_assignments_f asg,
7786: pay_assignment_actions paa,
7787: pay_payroll_actions ppa,
7788: per_time_periods ptp,
7789: pay_run_results prr,
7790: pay_element_types_f pet,
7791: pay_input_values_f piv1,
7792: pay_run_result_values rrv1,
7906: FROM per_people_f per,
7907: per_assignments_f asg,
7908: pay_assignment_actions paa,
7909: pay_payroll_actions ppa,
7910: per_time_periods ptp,
7911: pay_run_results prr,
7912: pay_element_types_f pet,
7913: pay_input_values_f piv1,
7914: pay_run_result_values rrv1
8016: FROM per_people_f per,
8017: per_assignments_f asg,
8018: pay_assignment_actions paa,
8019: pay_payroll_actions ppa,
8020: per_time_periods ptp,
8021: pay_run_results prr,
8022: pay_element_types_f pet,
8023: pay_input_values_f piv1,
8024: pay_run_result_values rrv1,