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.PQP_US_PENSION_EXTRACTS dependencies on HR_SOFT_CODING_KEYFLEX

Line 1169: ,hr_soft_coding_keyflex hsc

1165: CURSOR csr_gre_id (c_effective_date IN DATE
1166: ,c_assignment_id IN NUMBER) IS
1167: SELECT segment1
1168: FROM per_all_assignments_f paf
1169: ,hr_soft_coding_keyflex hsc
1170: WHERE hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1171: AND paf.assignment_id = c_assignment_id
1172: AND paf.business_group_id = g_business_group_id
1173: AND c_effective_date BETWEEN paf.effective_start_date

Line 4941: ,hr_soft_coding_keyflex hcf

4937:
4938: SELECT 'X'
4939:
4940: FROM per_all_assignments_f paf
4941: ,hr_soft_coding_keyflex hcf
4942:
4943: WHERE paf.assignment_id = c_assignment_id
4944: AND paf.business_group_id = c_business_group_id
4945: AND hcf.soft_coding_keyflex_id(+) = paf.soft_coding_keyflex_id

Line 4992: ,hr_soft_coding_keyflex hcf

4988: ,c_end_date IN DATE
4989: ) IS
4990: SELECT 'x'
4991: FROM per_all_assignments_f paf
4992: ,hr_soft_coding_keyflex hcf
4993: WHERE paf.assignment_id = c_assignment_id
4994: AND hcf.soft_coding_keyflex_id(+) = paf.soft_coding_keyflex_id
4995: AND (c_tax_unit_id IS NULL OR
4996: hcf.segment1 = Nvl(Fnd_Number.NUMBER_to_canonical(c_tax_unit_id), hcf.segment1)