DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on HR_ORGANIZATION_UNITS

Line 124: from hr_organization_units ou /*Bug No 2920728*/

120: , '0004' -- IR_form_version_no
121: -- Changes for bug 9237657 end
122: , 'TRANSFER_HEAD_FLAG=P'
123: , 'notprinted'
124: from hr_organization_units ou /*Bug No 2920728*/
125: , hr_organization_information oi
126: , pay_nz_er_cal_mth_bal_v b
127: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
128: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

Line 213: from hr_organization_units ou /*Bug No 2920728*/

209: b.earnings_not_liable_for_acc_ep,
210: b.paye_deductions,
211: b.child_support_deductions,b.student_loan_deductions)),-1,0 /* Bug No : 2755544 */
212: ,decode(sign(b.gross_earnings - (b.paye_deductions + b.child_support_deductions + b.student_loan_deductions)),-1,0,1)) flag
213: from hr_organization_units ou /*Bug No 2920728*/
214: , per_people_f p /*Bug No 2920728*/
215: , per_assignments_f a
216: , hr_soft_coding_keyflex scl
217: , pay_nz_asg_cal_mth_bal_v b