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.HXT_BATCH_VAL dependencies on PER_ASSIGNMENTS_F

Line 561: INDEX(paf PER_ASSIGNMENTS_F_N12)

557: )
558: IS
559:
560: SELECT /*+ ORDERED
561: INDEX(paf PER_ASSIGNMENTS_F_N12)
562: INDEX(past PER_ASSIGNMENT_STATUS_TYPE_PK) */
563: /* Hints supplied to always force the correct execution plan */
564: paf.assignment_id
565: FROM

Line 566: per_assignments_f paf,

562: INDEX(past PER_ASSIGNMENT_STATUS_TYPE_PK) */
563: /* Hints supplied to always force the correct execution plan */
564: paf.assignment_id
565: FROM
566: per_assignments_f paf,
567: per_assignment_status_types past
568: WHERE
569: paf.person_id = p_person_id AND
570: p_effective_date BETWEEN

Line 941: FROM per_assignments_f paf

937: p_effective_date DATE
938: )
939: IS
940: SELECT paf.business_group_id
941: FROM per_assignments_f paf
942: WHERE paf.assignment_id = p_asg_id
943: AND p_effective_date BETWEEN paf.effective_start_date
944: AND paf.effective_end_date;
945:

Line 946: l_business_group_id per_assignments_f.business_group_id%TYPE;

942: WHERE paf.assignment_id = p_asg_id
943: AND p_effective_date BETWEEN paf.effective_start_date
944: AND paf.effective_end_date;
945:
946: l_business_group_id per_assignments_f.business_group_id%TYPE;
947: l_legislation_code per_business_groups.legislation_code%TYPE;
948: BEGIN
949: g_debug :=hr_utility.debug_enabled;
950: if g_debug then

Line 983: INDEX(paf PER_ASSIGNMENTS_F_PK)

979: p_effective_date DATE
980: )
981: IS
982: SELECT /*+ ORDERED
983: INDEX(paf PER_ASSIGNMENTS_F_PK)
984: INDEX(past PER_ASSIGNMENT_STATUS_TYPE_PK) */
985: /* Hints supplied to always force the correct execution plan */
986: 1
987: FROM

Line 988: per_assignments_f paf,

984: INDEX(past PER_ASSIGNMENT_STATUS_TYPE_PK) */
985: /* Hints supplied to always force the correct execution plan */
986: 1
987: FROM
988: per_assignments_f paf,
989: per_assignment_status_types past
990: WHERE
991: paf.assignment_id = p_asg_id AND
992: p_effective_date BETWEEN

Line 1411: FROM per_assignments_f asg, pay_element_links_f el

1407: end if;
1408: BEGIN
1409: SELECT el.element_link_id
1410: INTO l_element_link_id
1411: FROM per_assignments_f asg, pay_element_links_f el
1412: WHERE asg.assignment_id = p_assignment_id
1413: AND el.business_group_id
1414: + 0 = asg.business_group_id
1415: + 0