APPS.PAY_US_MULTI_MMRF dependencies on PAY_ASSIGNMENT_ACTIONS

Line 62: pay_assignment_actions paa

58:
59: CURSOR C_EMP_count(cp_tax_unit_id number) IS
60: select count(*)
61: from pay_payroll_actions ppa,
62: pay_assignment_actions paa
63: where ppa.report_type = 'W2'
64: and report_qualifier = 'FED'
65: and effective_date = to_date('31/12/'||w2_year,'dd/mm/yyyy')
66: and ppa.payroll_action_id = paa.payroll_action_id

Line 121: pay_assignment_actions paa,

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'
124: and ppa.report_qualifier = 'FED'
125: and effective_date = to_date('31/12/'||w2_year,'dd/mm/yyyy')

Line 192: ,pay_assignment_actions paa

188: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD',nvl(sum(value),0) * 100
189: ) val
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

Line 218: ,pay_assignment_actions paa

214:
215: CURSOR c_ro_count ( cp_tax_unit_id number) IS
216: select count(*)
217: from pay_payroll_actions ppa
218: ,pay_assignment_actions paa
219: ,ff_archive_items fai
220: where ppa.report_type = 'W2'
221: and ppa.report_qualifier = 'FED'
222: and effective_date = to_date('31/12/'||w2_year,'dd/mm/yyyy')