DBA Data[Home] [Help]

APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 84: , PER_ALL_ASSIGNMENTS_F paa

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
85: , PAY_PAYROLL_ACTIONS ppa
86: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
87: and hoi1.organization_id = decode(pay_se_tax_card_req_pkg.get_parameter(ppa.legislative_parameters, 'REQUEST_FOR'),'ALL_ORG',hoi1.organization_id,pay_se_tax_card_req_pkg.get_parameter(ppa.legislative_parameters, 'REQUESTING_ORG'))
88: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 110: ,per_all_assignments_f paaf

106: in
107: ( SELECT /*+ INDEX(sck, HR_SOFT_CODING_KEYFLEX_PK) */ min(paaf.assignment_id),sck.segment2
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