DBA Data[Home] [Help]

APPS.PAY_FI_TAX_CARD_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 54: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

50: , HR_ORGANIZATION_INFORMATION hoi2
51: , HR_ORGANIZATION_INFORMATION hoi3
52: , HR_ORGANIZATION_INFORMATION hoi4
53: , HR_ORGANIZATION_INFORMATION hoi5
54: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
55: and pap.person_id = paa.person_id
56: and pap.BUSINESS_GROUP_ID = ppa.BUSINESS_GROUP_ID
57: and ppa.effective_date BETWEEN pap.effective_start_date and pap.effective_end_date
58: and paa.BUSINESS_GROUP_ID = ppa.BUSINESS_GROUP_ID