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 39: ,hr_organization_information hoi1

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

Line 40: ,hr_organization_information hoi2

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

Line 41: ,hr_organization_information hoi3

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

Line 42: ,hr_organization_information hoi4

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

Line 57: hr_organization_information hoi11

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

Line 58: ,hr_organization_information hoi22

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

Line 76: FROM HR_ORGANIZATION_INFORMATION hoi1

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

Line 77: , HR_ORGANIZATION_INFORMATION hoi2

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

Line 78: , HR_ORGANIZATION_INFORMATION hoi3

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

Line 79: , HR_ORGANIZATION_INFORMATION hoi4

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

Line 111: ,HR_ORGANIZATION_INFORMATION hroi

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