DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on FF_CONTEXTS

Line 602: ff_contexts ffc2

598: FROM pay_za_irp5_bal_codes irp5,
599: ff_archive_items arc,
600: ff_database_items dbi,
601: ff_archive_item_contexts faic2,
602: ff_contexts ffc2
603: WHERE irp5.code IN (3608, 3614, 3707, 3718, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3909, 3915, 3920)
604: AND irp5.balance_sequence = 3
605: AND irp5.user_name = dbi.user_name
606: AND dbi.user_entity_id = arc.user_entity_id

Line 625: ff_contexts ffc2

621: from pay_za_irp5_bal_codes irp5,
622: ff_archive_items arc,
623: ff_database_items dbi,
624: ff_archive_item_contexts faic2,
625: ff_contexts ffc2
626: where arc.context1 in (select ch.assignment_action_id
627: from pay_assignment_actions main
628: , pay_assignment_actions ch
629: where main.assignment_action_id = p_asg_act_id

Line 662: ff_contexts ffc2

658: FROM pay_za_irp5_bal_codes irp5,
659: ff_archive_items arc,
660: ff_database_items dbi,
661: ff_archive_item_contexts faic2,
662: ff_contexts ffc2
663: WHERE irp5.code IN (4001, 4002, 4003, 4004, 4006, 4007)
664: AND irp5.balance_sequence = 1
665: AND irp5.user_name = dbi.user_name
666: AND dbi.user_entity_id = arc.user_entity_id

Line 729: ff_contexts ffc

725: select paa.assignment_action_id
726: from pay_action_contexts pac,
727: pay_assignment_actions paa,
728: pay_payroll_actions ppa,
729: ff_contexts ffc
730: where paa.assignment_id = p_asgn_id
731: and paa.payroll_action_id = ppa.payroll_action_id
732: and ppa.action_type in ('R', 'Q','B')
733: AND pac.assignment_Action_id = paa.assignment_action_id

Line 929: ff_contexts ffc2

925: FROM ff_archive_items arc,
926: ff_database_items dbi,
927: pay_za_irp5_bal_codes irp5,
928: ff_archive_item_contexts faic2,
929: ff_contexts ffc2
930: WHERE arc.user_entity_id = dbi.user_entity_id
931: and irp5.user_name = dbi.user_name
932: and arc.context1 in (select ch.assignment_action_id
933: from pay_assignment_actions main

Line 953: ff_contexts ffc2

949: FROM ff_archive_items arc,
950: ff_database_items dbi,
951: pay_za_irp5_bal_codes irp5,
952: ff_archive_item_contexts faic2,
953: ff_contexts ffc2
954: WHERE arc.user_entity_id = dbi.user_entity_id
955: and irp5.user_name = dbi.user_name
956: and arc.context1 in (select ch.assignment_action_id
957: from pay_assignment_actions main