DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_ACTION_INFORMATION

Line 62: pay_action_information to

58: for performance reasons.
59: 20-JUN-2001 ahanda 115.10 Added check for category in
60: cursor check_tax_unit_fein.
61: 1849359 Added to_number in select from
62: pay_action_information to
63: work around bug 1822467
64: 22-APR-2001 ahanda 115.9 Changed range code to error out
65: if FEIN is not 9 chars.
66: 17-APR-2001 ahanda 115.8 Getting value if SS EE Withhled

Line 1021: from pay_action_information pai,

1017: ,nvl(sum(to_number(action_information27)),0) action_information27
1018: ,nvl(sum(to_number(action_information28)),0) action_information28
1019: ,nvl(sum(to_number(action_information29)),0) action_information29
1020: ,action_information30
1021: from pay_action_information pai,
1022: pay_assignment_actions paa,
1023: pay_payroll_actions ppa -- Bug 3343962
1024: where pai.tax_unit_id = cp_tax_unit_id
1025: and paa.payroll_action_id = cp_payroll_action_id