APPS.HR_JP_AST_UTILITY_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 524: INDEX(PPOS PER_PERIODS_OF_SERVICE_PK)

520: from (
521: select /*+ ORDERED
522: USE_NL(ASG1, PPOS, ASG2)
523: INDEX(ASG1 PER_ASSIGNMENTS_F_N7)
524: INDEX(PPOS PER_PERIODS_OF_SERVICE_PK)
525: INDEX(ASG2 PER_ASSIGNMENTS_F_PK) */
526: asg2.assignment_id,
527: min(asg2.effective_start_date) effective_start_date
528: from per_all_assignments_f asg1,

Line 529: per_periods_of_service ppos,

525: INDEX(ASG2 PER_ASSIGNMENTS_F_PK) */
526: asg2.assignment_id,
527: min(asg2.effective_start_date) effective_start_date
528: from per_all_assignments_f asg1,
529: per_periods_of_service ppos,
530: per_all_assignments_f asg2
531: where asg1.payroll_id = p_payroll_id
532: and p_effective_date
533: between asg1.effective_start_date and asg1.effective_end_date

Line 570: per_periods_of_service ppos,

566: asg2.assignment_id,
567: min(asg2.effective_start_date) effective_start_date
568: from hr_assignment_set_amendments asa,
569: per_all_assignments_f asg1,
570: per_periods_of_service ppos,
571: per_all_assignments_f asg2
572: where asa.assignment_set_id = p_assignment_set_id
573: and asa.include_or_exclude = 'I'
574: and asg1.assignment_id = asa.assignment_id

Line 607: INDEX(PPOS PER_PERIODS_OF_SERVICE_PK)

603: from (
604: select /*+ ORDERED
605: USE_NL(ASG1, PPOS, ASG2, ASA)
606: INDEX(ASG1 PER_ASSIGNMENTS_F_N7)
607: INDEX(PPOS PER_PERIODS_OF_SERVICE_PK)
608: INDEX(ASG2 PER_ASSIGNMENTS_F_PK)
609: INDEX(ASA HR_ASSIGNMENT_SET_AMENDMEN_PK) */
610: asg2.assignment_id,
611: min(asg2.effective_start_date) effective_start_date,

Line 614: per_periods_of_service ppos,

610: asg2.assignment_id,
611: min(asg2.effective_start_date) effective_start_date,
612: min(asa.include_or_exclude) include_or_exclude
613: from per_all_assignments_f asg1,
614: per_periods_of_service ppos,
615: per_all_assignments_f asg2,
616: hr_assignment_set_amendments asa
617: where asg1.payroll_id = p_payroll_id
618: and p_effective_date