DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on PAY_ACTION_INTERLOCKS

Line 3033: pay_action_interlocks pai,

3029: 'A_W2_HEALTH_COVERAGE_PER_GRE_YTD', nvl(sum(to_number(value)),0), --Bug 13497022
3030: 'A_W2_ROTH_457B_PER_GRE_YTD', nvl(sum(to_number(value)),0) --Bug 13497022
3031: ) val
3032: FROM ff_archive_items fai,
3033: pay_action_interlocks pai,
3034: pay_payroll_actions ppa,
3035: pay_assignment_actions paa,
3036: ff_user_entities fue
3037: where ppa.report_type = 'W2'

Line 3117: ,pay_action_interlocks pai

3113: FROM ff_archive_item_contexts faic
3114: ,ff_archive_items fai
3115: ,pay_assignment_actions paa
3116: ,pay_payroll_actions ppa
3117: ,pay_action_interlocks pai
3118: ,ff_user_entities fue
3119: WHERE
3120: ppa.report_type = 'W2'
3121: and ppa.report_qualifier = 'FED'

Line 3150: ,pay_action_interlocks pai

3146: FROM ff_archive_item_contexts faic
3147: ,ff_archive_items fai
3148: ,pay_assignment_actions paa
3149: ,pay_payroll_actions ppa
3150: ,pay_action_interlocks pai
3151: ,ff_user_entities fue
3152: WHERE
3153: ppa.report_type = 'W2'
3154: and ppa.report_qualifier = 'FED'