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_SE_TAX_CARD_REQ_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 40: ,hr_organization_information hoi1

36: ,'TEST_RUN=P', DECODE(pay_se_tax_card_req_pkg.get_parameter(ppa.legislative_parameters, 'TEST_RUN'),'Y','T',' ')
37: from
38: PAY_PAYROLL_ACTIONS ppa
39: ,hr_organization_units ou
40: ,hr_organization_information hoi1
41: ,hr_organization_information hoi2
42: ,hr_organization_information hoi3
43: ,hr_organization_information hoi4
44: ,HR_LOCATIONS_ALL HL

Line 41: ,hr_organization_information hoi2

37: from
38: PAY_PAYROLL_ACTIONS ppa
39: ,hr_organization_units ou
40: ,hr_organization_information hoi1
41: ,hr_organization_information hoi2
42: ,hr_organization_information hoi3
43: ,hr_organization_information hoi4
44: ,HR_LOCATIONS_ALL HL
45: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 42: ,hr_organization_information hoi3

38: PAY_PAYROLL_ACTIONS ppa
39: ,hr_organization_units ou
40: ,hr_organization_information hoi1
41: ,hr_organization_information hoi2
42: ,hr_organization_information hoi3
43: ,hr_organization_information hoi4
44: ,HR_LOCATIONS_ALL HL
45: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
46: AND ou.organization_id = PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'REQUESTING_ORG')

Line 43: ,hr_organization_information hoi4

39: ,hr_organization_units ou
40: ,hr_organization_information hoi1
41: ,hr_organization_information hoi2
42: ,hr_organization_information hoi3
43: ,hr_organization_information hoi4
44: ,HR_LOCATIONS_ALL HL
45: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
46: AND ou.organization_id = PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'REQUESTING_ORG')
47: and ou.business_group_id = ppa.business_group_id

Line 58: hr_organization_information hoi11

54: AND hoi3.organization_id = ou.organization_id
55: AND hoi3.ORG_INFORMATION_CONTEXT = 'SE_ORG_CONTACT_DETAILS'
56: AND hoi3.org_information_id = (select min(hoi22.org_information_id)
57: from
58: hr_organization_information hoi11
59: ,hr_organization_information hoi22
60: where
61: hoi11.organization_id = PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'REQUESTING_ORG')
62: AND hoi11.ORG_INFORMATION_CONTEXT='CLASS'

Line 59: ,hr_organization_information hoi22

55: AND hoi3.ORG_INFORMATION_CONTEXT = 'SE_ORG_CONTACT_DETAILS'
56: AND hoi3.org_information_id = (select min(hoi22.org_information_id)
57: from
58: hr_organization_information hoi11
59: ,hr_organization_information hoi22
60: where
61: hoi11.organization_id = PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'REQUESTING_ORG')
62: AND hoi11.ORG_INFORMATION_CONTEXT='CLASS'
63: AND hoi11.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 77: FROM HR_ORGANIZATION_INFORMATION hoi1

73:
74:
75: CURSOR CSR_SE_BODY is select /*+ INDEX(scl, HR_SOFT_CODING_KEYFLEX_PK) */ 'ORG_NUM=P', RPAD(hoi2.org_information2,12),
76: 'PERSON_NUM=P', RPAD((TO_CHAR(pap.DATE_OF_BIRTH,'CC')-2)||REPLACE(PAP.NATIONAL_IDENTIFIER,'-',''),12)
77: FROM HR_ORGANIZATION_INFORMATION hoi1
78: , HR_ORGANIZATION_INFORMATION hoi2
79: , HR_ORGANIZATION_INFORMATION hoi3
80: , HR_ORGANIZATION_INFORMATION hoi4
81: , PAY_LEGISLATION_RULES plr

Line 78: , HR_ORGANIZATION_INFORMATION hoi2

74:
75: CURSOR CSR_SE_BODY is select /*+ INDEX(scl, HR_SOFT_CODING_KEYFLEX_PK) */ 'ORG_NUM=P', RPAD(hoi2.org_information2,12),
76: 'PERSON_NUM=P', RPAD((TO_CHAR(pap.DATE_OF_BIRTH,'CC')-2)||REPLACE(PAP.NATIONAL_IDENTIFIER,'-',''),12)
77: FROM HR_ORGANIZATION_INFORMATION hoi1
78: , HR_ORGANIZATION_INFORMATION hoi2
79: , HR_ORGANIZATION_INFORMATION hoi3
80: , HR_ORGANIZATION_INFORMATION hoi4
81: , PAY_LEGISLATION_RULES plr
82: , HR_SOFT_CODING_KEYFLEX scl

Line 79: , HR_ORGANIZATION_INFORMATION hoi3

75: CURSOR CSR_SE_BODY is select /*+ INDEX(scl, HR_SOFT_CODING_KEYFLEX_PK) */ 'ORG_NUM=P', RPAD(hoi2.org_information2,12),
76: 'PERSON_NUM=P', RPAD((TO_CHAR(pap.DATE_OF_BIRTH,'CC')-2)||REPLACE(PAP.NATIONAL_IDENTIFIER,'-',''),12)
77: FROM HR_ORGANIZATION_INFORMATION hoi1
78: , HR_ORGANIZATION_INFORMATION hoi2
79: , HR_ORGANIZATION_INFORMATION hoi3
80: , HR_ORGANIZATION_INFORMATION hoi4
81: , PAY_LEGISLATION_RULES plr
82: , HR_SOFT_CODING_KEYFLEX scl
83: , PER_ALL_PEOPLE_F pap

Line 80: , HR_ORGANIZATION_INFORMATION hoi4

76: 'PERSON_NUM=P', RPAD((TO_CHAR(pap.DATE_OF_BIRTH,'CC')-2)||REPLACE(PAP.NATIONAL_IDENTIFIER,'-',''),12)
77: FROM HR_ORGANIZATION_INFORMATION hoi1
78: , HR_ORGANIZATION_INFORMATION hoi2
79: , HR_ORGANIZATION_INFORMATION hoi3
80: , HR_ORGANIZATION_INFORMATION hoi4
81: , PAY_LEGISLATION_RULES plr
82: , HR_SOFT_CODING_KEYFLEX scl
83: , PER_ALL_PEOPLE_F pap
84: , PER_ALL_ASSIGNMENTS_F paa

Line 112: ,HR_ORGANIZATION_INFORMATION hroi

108: FROM
109: per_all_people_f papf
110: ,per_all_assignments_f paaf
111: ,HR_SOFT_CODING_KEYFLEX sck
112: ,HR_ORGANIZATION_INFORMATION hroi
113: WHERE paaf.person_id = papf.person_id
114: and paaf.BUSINESS_GROUP_ID = ppa.BUSINESS_GROUP_ID
115: and ppa.effective_date BETWEEN paaf.effective_start_date and paaf.effective_end_date
116: and ppa.effective_date BETWEEN papf.effective_start_date and papf.effective_end_date