DBA Data[Home] [Help]

APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on FF_CONTEXTS

Line 398: from pay_action_contexts pac, ff_contexts fc

394: and hoi.org_information2 = to_char(cp_pre_id) ))
395: )
396: AND PPY.payroll_id = ASG.payroll_id
397: AND EXISTS (select 'X'
398: from pay_action_contexts pac, ff_contexts fc
399: where pac.assignment_id = asg.assignment_id
400: and pac.context_id = fc.context_id
401: and fc.context_name = 'JURISDICTION_CODE'
402: and pac.context_value = 'QC')

Line 438: AND EXISTS (select 'X' from pay_action_contexts pac, ff_contexts fc

434: where hoi.org_information_context = 'Canada Employer Identification'
435: and hoi.org_information2 = to_char(cp_pre_id)
436: and hoi.org_information5 = 'T4A/RL2')
437: AND PPY.payroll_id = ASG.payroll_id
438: AND EXISTS (select 'X' from pay_action_contexts pac, ff_contexts fc
439: where pac.assignment_id = asg.assignment_id
440: and pac.context_id = fc.context_id
441: and fc.context_name = 'JURISDICTION_CODE'
442: and pac.context_value = 'QC')