APPS.PAY_IE_P35 dependencies on PER_TIME_PERIODS

Line 120: per_time_periods ptp

116: SELECT MAX(paa.assignment_action_id)
117: FROM per_assignments_f paf,
118: pay_assignment_actions paa,
119: pay_payroll_actions ppa,
120: per_time_periods ptp
121: WHERE paf.person_id = l_person_id
122: AND paf.assignment_id = paa.assignment_id
123: AND paa.action_status = 'C'
124: AND ppa.payroll_action_id = paa.payroll_action_id

Line 244: per_time_periods ptp,

240: FROM per_people_f per,
241: per_assignments_f asg,
242: pay_assignment_actions paa,
243: pay_payroll_actions ppa,
244: per_time_periods ptp,
245: pay_run_results prr,
246: pay_element_types_f pet,
247: pay_input_values_f piv1,
248: pay_run_result_values rrv1

Line 804: per_time_periods ptp,

800: FROM per_assignments_f asg,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_all_payrolls_f pap,
804: per_time_periods ptp,
805: hr_soft_coding_keyflex flex
806: WHERE paa.source_action_id IS NULL
807: AND paa.payroll_action_id = ppa.payroll_action_id
808: --Added for date track updates of payroll with diff pay ref no

Line 832: per_time_periods ptp1 --Tar 15081088.6

828: (SELECT MAX (paf.effective_end_date)
829: FROM per_assignments_f paf,
830: pay_assignment_actions paa1, --Bug fix 4130665
831: pay_payroll_actions ppa1,
832: per_time_periods ptp1 --Tar 15081088.6
833: ,pay_all_payrolls_f pay
834: ,hr_soft_coding_keyflex flex1
835: WHERE paf.person_id = asg.person_id
836: -- AND paf.primary_flag = 'Y'

Line 1432: per_time_periods ptp,

1428: pay_action_information pact_ad,
1429: per_assignments_f paf,
1430: per_periods_of_service pps,
1431: -- pay_ie_paye_details_f payef,
1432: per_time_periods ptp,
1433: per_people_f ppf
1434: WHERE pact_iedi.action_information_category = 'IE EMPLOYEE DETAILS'
1435: AND pact_iedi.action_context_type = 'AAP'
1436: AND pact_iedi.action_context_id = p_locked_action

Line 1916: per_time_periods ptp,

1912: 0) --Bug 4111753
1913: /*( NVL(paye.weekly_tax_credit,0) +
1914: NVL(paye.Monthly_tax_credit,0)) * ptp.period_num */
1915: FROM per_assignments_f paf,
1916: per_time_periods ptp,
1917: pay_ie_paye_details_f paye
1918: WHERE paf.assignment_id = p_assignment_id
1919: AND paye.assignment_id=paf.assignment_id
1920: AND p_term_date between paf.effective_start_date

Line 2011: -- ,per_time_periods ptp -- removed to improve performance 4771780

2007: CURSOR c_get_max_aact(p_pds_id NUMBER) IS
2008: SELECT max(paa.assignment_action_id)
2009: FROM pay_assignment_Actions paa,
2010: pay_payroll_actions ppa
2011: -- ,per_time_periods ptp -- removed to improve performance 4771780
2012: WHERE paa.assignment_id in (SELECT assignment_id
2013: FROM per_assignments_f
2014: WHERE period_of_service_id = p_pds_id)
2015: AND paa.payroll_action_id = ppa.payroll_action_id

Line 4678: per_time_periods ptp

4674: FROM per_people_f ppf,
4675: per_assignments_f paf,
4676: pay_assignment_actions paa,
4677: pay_payroll_actions ppa,
4678: per_time_periods ptp
4679: WHERE
4680: ppf.person_id = p_person_id
4681: AND paf.assignment_id = p_assignment_id -- vik added code for getting values for given assignment
4682: AND ppf.current_employee_flag = 'Y'

Line 4723: per_time_periods ptp,

4719: FROM per_people_f per,
4720: per_assignments_f asg,
4721: pay_assignment_actions paa,
4722: pay_payroll_actions ppa,
4723: per_time_periods ptp,
4724: pay_run_results prr,
4725: pay_element_types_f pet,
4726: pay_input_values_f piv1,
4727: pay_run_result_values rrv1,

Line 4843: per_time_periods ptp,

4839: FROM per_people_f per,
4840: per_assignments_f asg,
4841: pay_assignment_actions paa,
4842: pay_payroll_actions ppa,
4843: per_time_periods ptp,
4844: pay_run_results prr,
4845: pay_element_types_f pet,
4846: pay_input_values_f piv1,
4847: pay_run_result_values rrv1