DBA Data[Home] [Help]

APPS.PAY_PURGE_PKG dependencies on FF_CONTEXTS

Line 765: ff_contexts ffc

761: ffc.context_id,
762: ffc.context_name,
763: rep.jurisdiction_code
764: from pay_us_asg_reporting rep,
765: ff_contexts ffc
766: where rep.assignment_id = p_assignment_id
767: and ffc.context_name = 'JURISDICTION_CODE'
768: and rep.jurisdiction_code is not null
769: union all

Line 778: from ff_contexts ffc,

774: select distinct
775: ffc.context_id,
776: ffc.context_name,
777: to_char(paa.tax_unit_id)
778: from ff_contexts ffc,
779: pay_assignment_actions paa,
780: pay_payroll_actions ppa
781: where ffc.context_name = 'TAX_UNIT_ID'
782: and paa.assignment_id = p_assignment_id

Line 801: from ff_contexts ffc,

797: open p_ctx_cursor for
798: select ffc.context_id,
799: ffc.context_name,
800: to_char(act.tax_unit_id) context_value
801: from ff_contexts ffc,
802: pay_assignment_actions act,
803: pay_payroll_actions pac
804: where act.assignment_id = p_assignment_id
805: and pac.payroll_action_id = act.payroll_action_id

Line 814: ff_contexts ffc,

810: select ctx.context_id,
811: ffc.context_name,
812: ctx.context_value
813: from pay_action_contexts ctx,
814: ff_contexts ffc,
815: pay_assignment_actions act,
816: pay_payroll_actions pac
817: where ctx.assignment_id = p_assignment_id
818: and ffc.context_id = ctx.context_id