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.PYGBEXC dependencies on PAY_ASSIGNMENT_ACTIONS

Line 508: pay_assignment_actions paa

504: -1,-1,0)),'DD-MM-YYYY') finyear
505: into l_tax_year_start
506: from per_time_periods PTP,
507: pay_payroll_actions ppa,
508: pay_assignment_actions paa
509: where ppa.payroll_action_id = paa.payroll_action_id
510: and paa.assignment_action_id = p_asg_action
511: and ppa.payroll_id = p_payroll_id
512: and PTP.time_period_id = ppa.time_period_id;

Line 548: pay_assignment_actions paa

544: -1,-1,0)),'DD-MM-YYYY') finyear
545: into l_tax_year_start
546: from per_time_periods PTP,
547: pay_payroll_actions ppa,
548: pay_assignment_actions paa
549: where ppa.payroll_action_id = paa.payroll_action_id
550: and paa.assignment_action_id = p_asg_action
551: and ppa.payroll_id = p_payroll_id
552: and PTP.time_period_id = ppa.time_period_id;

Line 599: pay_assignment_actions paa

595: -1,-1,0)),'DD-MM-YYYY') finyear
596: into l_tax_year_start
597: from per_time_periods PTP,
598: pay_payroll_actions ppa,
599: pay_assignment_actions paa
600: where ppa.payroll_action_id = paa.payroll_action_id
601: and paa.assignment_action_id = p_asg_action
602: and ppa.payroll_id = p_payroll_id
603: and PTP.time_period_id = ppa.time_period_id;

Line 649: pay_assignment_actions paa

645: -1,-1,0)),'DD-MM-YYYY') finyear
646: into l_tax_year_start
647: from per_time_periods PTP,
648: pay_payroll_actions ppa,
649: pay_assignment_actions paa
650: where ppa.payroll_action_id = paa.payroll_action_id
651: and paa.assignment_action_id = p_asg_action
652: and ppa.payroll_id = p_payroll_id
653: and PTP.time_period_id = ppa.time_period_id;