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.PAY_FI_TAX_CARD_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 49: , HR_ORGANIZATION_INFORMATION hoi1

45: , PER_ALL_PEOPLE_F pap
46: , PER_ALL_ASSIGNMENTS_F paa
47: , PAY_LEGISLATION_RULES plr
48: , HR_SOFT_CODING_KEYFLEX scl
49: , HR_ORGANIZATION_INFORMATION hoi1
50: , HR_ORGANIZATION_INFORMATION hoi2
51: , HR_ORGANIZATION_INFORMATION hoi3
52: , HR_ORGANIZATION_INFORMATION hoi4
53: , HR_ORGANIZATION_INFORMATION hoi5

Line 50: , HR_ORGANIZATION_INFORMATION hoi2

46: , PER_ALL_ASSIGNMENTS_F paa
47: , PAY_LEGISLATION_RULES plr
48: , HR_SOFT_CODING_KEYFLEX scl
49: , HR_ORGANIZATION_INFORMATION hoi1
50: , HR_ORGANIZATION_INFORMATION hoi2
51: , HR_ORGANIZATION_INFORMATION hoi3
52: , HR_ORGANIZATION_INFORMATION hoi4
53: , HR_ORGANIZATION_INFORMATION hoi5
54: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 51: , HR_ORGANIZATION_INFORMATION hoi3

47: , PAY_LEGISLATION_RULES plr
48: , HR_SOFT_CODING_KEYFLEX scl
49: , HR_ORGANIZATION_INFORMATION hoi1
50: , HR_ORGANIZATION_INFORMATION hoi2
51: , HR_ORGANIZATION_INFORMATION hoi3
52: , HR_ORGANIZATION_INFORMATION hoi4
53: , HR_ORGANIZATION_INFORMATION hoi5
54: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
55: and pap.person_id = paa.person_id

Line 52: , HR_ORGANIZATION_INFORMATION hoi4

48: , HR_SOFT_CODING_KEYFLEX scl
49: , HR_ORGANIZATION_INFORMATION hoi1
50: , HR_ORGANIZATION_INFORMATION hoi2
51: , HR_ORGANIZATION_INFORMATION hoi3
52: , HR_ORGANIZATION_INFORMATION hoi4
53: , HR_ORGANIZATION_INFORMATION hoi5
54: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
55: and pap.person_id = paa.person_id
56: and pap.BUSINESS_GROUP_ID = ppa.BUSINESS_GROUP_ID

Line 53: , HR_ORGANIZATION_INFORMATION hoi5

49: , HR_ORGANIZATION_INFORMATION hoi1
50: , HR_ORGANIZATION_INFORMATION hoi2
51: , HR_ORGANIZATION_INFORMATION hoi3
52: , HR_ORGANIZATION_INFORMATION hoi4
53: , HR_ORGANIZATION_INFORMATION hoi5
54: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
55: and pap.person_id = paa.person_id
56: and pap.BUSINESS_GROUP_ID = ppa.BUSINESS_GROUP_ID
57: and ppa.effective_date BETWEEN pap.effective_start_date and pap.effective_end_date

Line 69: ,HR_ORGANIZATION_INFORMATION hoi6

65: and (paa.assignment_id,pap.person_id ) in (SELECT /*+ INDEX(scl1, HR_SOFT_CODING_KEYFLEX_PK) */ min(paa.assignment_id),pap1.person_id
66: FROM per_all_assignments_f paa
67: ,per_all_people_f pap1
68: ,HR_SOFT_CODING_KEYFLEX scl1
69: ,HR_ORGANIZATION_INFORMATION hoi6
70: WHERE paa.person_id = pap1.person_id
71: and ppa.BUSINESS_GROUP_ID = pap1.BUSINESS_GROUP_ID
72: and ppa.effective_date BETWEEN pap1.effective_start_date and pap1.effective_end_date
73: and ppa.effective_date BETWEEN paa.effective_start_date and paa.effective_end_date