[Home] [Help]
47: from pay_assignment_actions paa,
48: pay_action_information pai,
49: ff_archive_items fai,
50: ff_archive_item_contexts fic,
51: ff_user_entities fue,
52: ff_contexts ffc,
53: pay_payroll_actions ppa
54: where paa.payroll_action_id = ye_payroll_action_id
55: and paa.payroll_action_id = ppa.payroll_action_id
149: pay_balance_attributes pba,
150: pay_defined_balances pdb_attr,
151: pay_defined_balances pdb_call,
152: pay_balance_dimensions pbd,
153: ff_user_entities fue_live
154: WHERE pbad.attribute_name = 'Year End Balances'
155: AND pbad.legislation_code = 'MX'
156: AND pba.attribute_id = pbad.attribute_id
157: AND pdb_attr.defined_balance_id = pba.defined_balance_id