eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JP_AST_UTILITY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 528: from per_all_assignments_f asg1,

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,
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

Line 530: per_all_assignments_f asg2

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
534: and ppos.period_of_service_id = asg1.period_of_service_id

Line 543: per_all_assignments_f asg3,

539: and asg2.effective_start_date <= p_end_date
540: and asg2.payroll_id +0 = asg1.payroll_id
541: group by asg2.assignment_id
542: ) v,
543: per_all_assignments_f asg3,
544: per_all_people_f per
545: --
546: -- Assignment information must be retrieved by Batch Line Upload Date.
547: --

Line 569: per_all_assignments_f asg1,

565: select /*+ ORDERED */
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'

Line 571: per_all_assignments_f asg2

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
575: and p_effective_date

Line 587: per_all_assignments_f asg3,

583: and asg2.effective_start_date <= p_end_date
584: and asg2.payroll_id + 0 = asg1.payroll_id
585: group by asg2.assignment_id
586: ) v,
587: per_all_assignments_f asg3,
588: per_all_people_f per
589: where asg3.assignment_id = v.assignment_id
590: and asg3.effective_start_date = v.effective_start_date
591: and per.person_id = asg3.person_id

Line 613: from per_all_assignments_f asg1,

609: INDEX(ASA HR_ASSIGNMENT_SET_AMENDMEN_PK) */
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

Line 615: per_all_assignments_f asg2,

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
619: between asg1.effective_start_date and asg1.effective_end_date

Line 632: per_all_assignments_f asg3,

628: and asa.assignment_id(+) = asg2.assignment_id
629: and nvl(asa.include_or_exclude, 'I') = 'I'
630: group by asg2.assignment_id
631: ) v,
632: per_all_assignments_f asg3,
633: per_all_people_f per
634: where asg3.assignment_id = v.assignment_id
635: and asg3.effective_start_date = v.effective_start_date
636: and per.person_id = asg3.person_id