DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on FF_CONTEXTS

Line 441: ff_contexts ffc2

437: FROM pay_za_irp5_bal_codes irp5,
438: ff_archive_items arc,
439: ff_database_items dbi,
440: ff_archive_item_contexts faic2,
441: ff_contexts ffc2
442: WHERE irp5.code IN (3608, 3614, 3707, 3718, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3915)
443: AND irp5.balance_sequence = 3
444: AND irp5.user_name = dbi.user_name
445: AND dbi.user_entity_id = arc.user_entity_id

Line 464: ff_contexts ffc2

460: from pay_za_irp5_bal_codes irp5,
461: ff_archive_items arc,
462: ff_database_items dbi,
463: ff_archive_item_contexts faic2,
464: ff_contexts ffc2
465: where arc.context1 in (select ch.assignment_action_id
466: from pay_assignment_actions main
467: , pay_assignment_actions ch
468: where main.assignment_action_id = p_asg_act_id

Line 502: ff_contexts ffc2

498: FROM pay_za_irp5_bal_codes irp5,
499: ff_archive_items arc,
500: ff_database_items dbi,
501: ff_archive_item_contexts faic2,
502: ff_contexts ffc2
503: WHERE irp5.code IN (4001, 4002, 4003, 4004, 4006, 4007)
504: AND irp5.balance_sequence = 1
505: AND irp5.user_name = dbi.user_name
506: AND dbi.user_entity_id = arc.user_entity_id

Line 548: ff_contexts ffc

544: select paa.assignment_action_id
545: from pay_action_contexts pac,
546: pay_assignment_actions paa,
547: pay_payroll_actions ppa,
548: ff_contexts ffc
549: where paa.assignment_id = p_asgn_id
550: and paa.payroll_action_id = ppa.payroll_action_id
551: and ppa.action_type in ('R', 'Q','B')
552: AND pac.assignment_Action_id = paa.assignment_action_id