DBA Data[Home] [Help]

APPS.PAY_YEAR_END_EXTRACT dependencies on PER_TIME_PERIOD_TYPES

Line 1804: per_time_period_types ptpt

1800: ye_asg.SUPERANNUATION_PAID *
1801: sign(ye_asg.SUPERANNUATION_PAID) SUPERANNUATION_PAID,
1802: nvl(ye_asg.TAX_CODE,'NI') TAX_CODE
1803: from pay_gb_year_end_payrolls ye_roll,
1804: per_time_period_types ptpt
1805: where ye_roll.payroll_id = ye_asg.payroll_id
1806: and ye_roll.period_type = ptpt.period_type
1807: and ye_asg.request_id = p_request_id )
1808: where ye_asg.request_id = p_request_id;