DBA Data[Home] [Help]

APPS.PYGBEXC dependencies on PAY_ASSIGNMENT_ACTIONS

Line 784: pay_assignment_actions paa

780: -1,-1,0)),'DD-MM-YYYY') finyear
781: into l_tax_year_start
782: from per_time_periods PTP,
783: pay_payroll_actions ppa,
784: pay_assignment_actions paa
785: where ppa.payroll_action_id = paa.payroll_action_id
786: and paa.assignment_action_id = p_asg_action
787: and ppa.payroll_id = p_payroll_id
788: and PTP.time_period_id = ppa.time_period_id;

Line 824: pay_assignment_actions paa

820: -1,-1,0)),'DD-MM-YYYY') finyear
821: into l_tax_year_start
822: from per_time_periods PTP,
823: pay_payroll_actions ppa,
824: pay_assignment_actions paa
825: where ppa.payroll_action_id = paa.payroll_action_id
826: and paa.assignment_action_id = p_asg_action
827: and ppa.payroll_id = p_payroll_id
828: and PTP.time_period_id = ppa.time_period_id;

Line 875: pay_assignment_actions paa

871: -1,-1,0)),'DD-MM-YYYY') finyear
872: into l_tax_year_start
873: from per_time_periods PTP,
874: pay_payroll_actions ppa,
875: pay_assignment_actions paa
876: where ppa.payroll_action_id = paa.payroll_action_id
877: and paa.assignment_action_id = p_asg_action
878: and ppa.payroll_id = p_payroll_id
879: and PTP.time_period_id = ppa.time_period_id;

Line 925: pay_assignment_actions paa

921: -1,-1,0)),'DD-MM-YYYY') finyear
922: into l_tax_year_start
923: from per_time_periods PTP,
924: pay_payroll_actions ppa,
925: pay_assignment_actions paa
926: where ppa.payroll_action_id = paa.payroll_action_id
927: and paa.assignment_action_id = p_asg_action
928: and ppa.payroll_id = p_payroll_id
929: and PTP.time_period_id = ppa.time_period_id;