DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on HR_ORGANIZATION_UNITS

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

83: -- Changed IR_form_version_no below for bug 5846247
84: , '0002' -- IR_form_version_no
85: , 'TRANSFER_HEAD_FLAG=P'
86: , 'notprinted'
87: from hr_organization_units ou /*Bug No 2920728*/
88: , hr_organization_information oi
89: , pay_nz_er_cal_mth_bal_v b
90: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
91: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

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

162: b.earnings_not_liable_for_acc_ep,
163: b.paye_deductions,
164: b.child_support_deductions,b.student_loan_deductions)),-1,0 /* Bug No : 2755544 */
165: ,decode(sign(b.gross_earnings - (b.paye_deductions + b.child_support_deductions + b.student_loan_deductions)),-1,0,1)) flag
166: from hr_organization_units ou /*Bug No 2920728*/
167: , per_people_f p /*Bug No 2920728*/
168: , per_assignments_f a
169: , hr_soft_coding_keyflex scl
170: , pay_nz_asg_cal_mth_bal_v b