DBA Data[Home] [Help]

APPS.PAY_US_MULTI_MMRF dependencies on PAY_ACTION_INTERLOCKS

Line 119: pay_action_interlocks pai,

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

Line 194: ,pay_action_interlocks pai

190: FROM ff_archive_item_contexts faic
191: ,ff_archive_items fai
192: ,pay_assignment_actions paa
193: ,pay_payroll_actions ppa
194: ,pay_action_interlocks pai
195: ,ff_user_entities fue
196: WHERE
197: ppa.report_type = 'W2'
198: and ppa.report_qualifier = 'FED'