APPS.PAY_CA_T4_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 434: from hr_assignment_set_amendments hasa

430: and faic.context = nvl(rtrim(p_prov), faic.context)
431: and faic.context_id = fc.context_id
432: and fc.context_name = 'JURISDICTION_CODE'
433: AND exists ( select 1 /* Selected Assignment Set */
434: from hr_assignment_set_amendments hasa
435: where hasa.assignment_set_id = l_asg_set_id
436: and hasa.assignment_id = paf.assignment_id
437: and upper(hasa.include_or_exclude) = 'I');
438:

Line 473: from hr_assignment_set_amendments hasa

469: and faic.context = nvl(rtrim(p_prov), faic.context)
470: and faic.context_id = fc.context_id
471: and fc.context_name = 'JURISDICTION_CODE'
472: AND exists ( select 1 /* Selected Assignment Set */
473: from hr_assignment_set_amendments hasa
474: where hasa.assignment_set_id = l_asg_set_id
475: and hasa.assignment_id = paf.assignment_id
476: and upper(hasa.include_or_exclude) = 'I')
477: and ppr.payroll_action_id = pactid

Line 514: from hr_assignment_set_amendments hasa

510: and faic.context = nvl(rtrim(p_prov), faic.context)
511: and faic.context_id = fc.context_id
512: and fc.context_name = 'JURISDICTION_CODE'
513: AND exists ( select 1 /* Selected Assignment Set */
514: from hr_assignment_set_amendments hasa
515: where hasa.assignment_set_id = l_asg_set_id
516: and hasa.assignment_id = paf.assignment_id
517: and upper(hasa.include_or_exclude) = 'I')
518: and pds.actual_termination_date is not null

Line 555: from hr_assignment_set_amendments hasa

551: and faic.context = nvl(rtrim(p_prov), faic.context)
552: and faic.context_id = fc.context_id
553: and fc.context_name = 'JURISDICTION_CODE'
554: AND exists ( select 1 /* Selected Assignment Set */
555: from hr_assignment_set_amendments hasa
556: where hasa.assignment_set_id = l_asg_set_id
557: and hasa.assignment_id = paf.assignment_id
558: and upper(hasa.include_or_exclude) = 'I')
559: and ppr.payroll_action_id = pactid