17: ,'REQUESTER_ID_CODE=P' ,nvl(hoi.org_information1,' ')
18: ,'USER_CONTROL_DATA=P' ,nvl(hoi.org_information2,' ')
19: ,'MULTI_REQ_INDICATOR=P' ,nvl(hoi.org_information3,' ')
20:
21: FROM pay_assignment_actions paa
22: ,per_all_assignments_f paf
23: ,per_all_people_f ppf
24: ,hr_organization_information hoi
25:
51: , 'REQUESTER_ID_CODE=P' ,nvl(hoi.org_information1,' ')
52: , 'USER_CONTROL_DATA=P' ,nvl(hoi.org_information2,' ')
53: , 'MULTI_REQ_INDICATOR=P' ,nvl(hoi.org_information3,' ')
54: From
55: pay_assignment_actions paa
56: ,per_all_assignments_f paf
57: ,per_all_people_f ppf
58: ,hr_organization_information hoi
59: where