eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_EYU dependencies on PER_TIME_PERIODS

Line 3915: , per_time_periods ptp

3911: || paa.assignment_action_id), 16))
3912: , max (pact.effective_date) effective_date
3913: FROM pay_assignment_actions paa
3914: , pay_payroll_actions pact
3915: , per_time_periods ptp
3916: WHERE paa.assignment_id = asg_id
3917: AND paa.payroll_action_id = pact.payroll_action_id
3918: AND pact.time_period_id = ptp.time_period_id
3919: AND pact.action_type IN ('Q', 'R', 'B'

Line 3962: , per_time_periods ptp,

3958: cursor csr_all_actions_tax_year (asg_id number)is
3959: select paa.assignment_action_id asg_act_id
3960: FROM pay_assignment_actions paa
3961: , pay_payroll_actions pact
3962: , per_time_periods ptp,
3963: per_all_assignments_f paaf,
3964: pay_all_payrolls_f pay,
3965: hr_soft_coding_keyflex sck
3966:

Line 4019: , per_time_periods ptp,

4015: select paa.ASSIGNMENT_ACTION_ID asg_act_id
4016: FROM per_all_assignments_f paaf,
4017: pay_assignment_actions paa
4018: , pay_payroll_actions pact
4019: , per_time_periods ptp,
4020: pay_all_payrolls_f pay,
4021: hr_soft_coding_keyflex sck
4022: WHERE paa.assignment_id = paaf.assignment_id
4023: and paaf.person_id = per_id

Line 4056: , per_time_periods ptp,

4052:
4053: FROM per_all_assignments_f paaf,
4054: pay_assignment_actions paa
4055: , pay_payroll_actions pact
4056: , per_time_periods ptp,
4057: pay_all_payrolls_f pay,
4058: hr_soft_coding_keyflex sck
4059: WHERE paa.assignment_id = paaf.assignment_id
4060: and paaf.person_id = per_id

Line 4093: , per_time_periods ptp,

4089:
4090: FROM per_all_assignments_f paaf,
4091: pay_assignment_actions paa
4092: , pay_payroll_actions pact
4093: , per_time_periods ptp,
4094: pay_all_payrolls_f pay,
4095: hr_soft_coding_keyflex sck
4096: WHERE paa.assignment_id = paaf.assignment_id
4097: and paaf.person_id = per_id

Line 5376: , per_time_periods ptp

5372: || paa.assignment_action_id), 16))
5373: , max (pact.effective_date) effective_date
5374: FROM pay_assignment_actions paa
5375: , pay_payroll_actions pact
5376: , per_time_periods ptp
5377: WHERE paa.assignment_id = asg_id
5378: AND paa.payroll_action_id = pact.payroll_action_id
5379: AND pact.time_period_id = ptp.time_period_id
5380: AND pact.action_type IN ('Q', 'R', 'B'

Line 5399: , per_time_periods ptp,

5395:
5396: FROM per_all_assignments_f paaf,
5397: pay_assignment_actions paa
5398: , pay_payroll_actions pact
5399: , per_time_periods ptp,
5400: pay_all_payrolls_f pay,
5401: hr_soft_coding_keyflex sck
5402: WHERE paa.assignment_id = paaf.assignment_id
5403: and paaf.person_id = person_id