DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on PAY_ACTION_INTERLOCKS

Line 2533: pay_action_interlocks pai,

2529: 'A_W2_ROTH_401K_PER_GRE_YTD', nvl(sum(to_number(value)),0) ,
2530: 'A_W2_ROTH_403B_PER_GRE_YTD', nvl(sum(to_number(value)),0)
2531: ) val
2532: FROM ff_archive_items fai,
2533: pay_action_interlocks pai,
2534: pay_payroll_actions ppa,
2535: pay_assignment_actions paa,
2536: ff_user_entities fue
2537: where ppa.report_type = 'W2'

Line 2611: ,pay_action_interlocks pai

2607: FROM ff_archive_item_contexts faic
2608: ,ff_archive_items fai
2609: ,pay_assignment_actions paa
2610: ,pay_payroll_actions ppa
2611: ,pay_action_interlocks pai
2612: ,ff_user_entities fue
2613: WHERE
2614: ppa.report_type = 'W2'
2615: and ppa.report_qualifier = 'FED'

Line 2644: ,pay_action_interlocks pai

2640: FROM ff_archive_item_contexts faic
2641: ,ff_archive_items fai
2642: ,pay_assignment_actions paa
2643: ,pay_payroll_actions ppa
2644: ,pay_action_interlocks pai
2645: ,ff_user_entities fue
2646: WHERE
2647: ppa.report_type = 'W2'
2648: and ppa.report_qualifier = 'FED'