APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_ACTION_INFORMATION

Line 71: pay_action_information to

67: for performance reasons.
68: 20-JUN-2001 ahanda 115.10 Added check for category in
69: cursor check_tax_unit_fein.
70: 1849359 Added to_number in select from
71: pay_action_information to
72: work around bug 1822467
73: 22-APR-2001 ahanda 115.9 Changed range code to error out
74: if FEIN is not 9 chars.
75: 17-APR-2001 ahanda 115.8 Getting value if SS EE Withhled

Line 1067: from pay_action_information pai,

1063: ,nvl(sum(to_number(action_information27)),0) action_information27
1064: ,nvl(sum(to_number(action_information28)),0) action_information28
1065: ,nvl(sum(to_number(action_information29)),0) action_information29
1066: ,action_information30
1067: from pay_action_information pai,
1068: pay_assignment_actions paa,
1069: pay_payroll_actions ppa -- Bug 3343962
1070: where pai.tax_unit_id = cp_tax_unit_id
1071: and paa.payroll_action_id = cp_payroll_action_id

Line 1124: from pay_action_information pai,

1120: ,nvl(sum(to_number(decode(pai.action_information_category,'US STATE2',action_information1,0))),0) sdi1_ee
1121: ,nvl(sum(to_number(decode(pai.action_information_category,'US FEDERAL',decode(action_information27,'Y',0,action_information2),action_information2))),0) action_information31 --Added for Bug#9872952
1122: ,nvl(sum(to_number(decode(pai.action_information_category,'US FEDERAL',decode(action_information27,'Y',0,action_information5),action_information5))),0) action_information32 --Added for Bug#9872952
1123: ,nvl(sum(to_number(decode(pai.action_information_category,'US FEDERAL',decode(action_information27,'Y',0,action_information23),action_information23))),0) action_information33 --Added for Bug#9872952
1124: from pay_action_information pai,
1125: pay_assignment_actions paa,
1126: pay_payroll_actions ppa
1127: where pai.tax_unit_id = cp_tax_unit_id
1128: and paa.payroll_action_id = cp_payroll_action_id