DBA Data[Home] [Help]

APPS.PAY_US_MULTI_MMRF dependencies on PAY_ACTION_INTERLOCKS

Line 122: pay_action_interlocks pai,

118: , 'A_W2_ROTH_401K_PER_GRE_YTD', nvl(sum(value),0) * 100
119: , 'A_W2_ROTH_403B_PER_GRE_YTD', nvl(sum(value),0) * 100
120: ) val
121: FROM ff_archive_items fai,
122: pay_action_interlocks pai,
123: pay_payroll_actions ppa,
124: pay_assignment_actions paa,
125: ff_user_entities fue
126: where ppa.report_type = 'W2'

Line 200: ,pay_action_interlocks pai

196: FROM ff_archive_item_contexts faic
197: ,ff_archive_items fai
198: ,pay_assignment_actions paa
199: ,pay_payroll_actions ppa
200: ,pay_action_interlocks pai
201: ,ff_user_entities fue
202: WHERE
203: ppa.report_type = 'W2'
204: and ppa.report_qualifier = 'FED'