DBA Data[Home] [Help]

APPS.PAY_IE_PAYFILE_SEPA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 74: ,hr_all_organization_units hou --15971893

70: ,'TRANSFER_CATG_PURP=P', NVL(pay_ie_payfile_sepa.get_parameter(ppa.legislative_parameters,'SEPA_CATEGORY'),'SALA')
71: --15971893
72: FROM pay_payroll_actions ppa
73: ,pay_org_payment_methods_f popmf --15971893
74: ,hr_all_organization_units hou --15971893
75: WHERE ppa.payroll_action_id =
76: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
77: AND ppa.org_payment_method_id = popmf.org_payment_method_id --15971893
78: AND hou.business_group_id = ppa.business_group_id --15971893

Line 104: from hr_all_organization_units hou,

100: ,'TRANSFER_ER_COUNT_LAST=P' ,'0'
101: ,'TRANSFER_ER_TOTAL_LAST=P' ,'0'
102: ,'TRANSFER_ORG_PAY_METH_ID=P',popmf.org_payment_method_id
103: ,'TRANSFER_ORG_PAY_METH_N=P',popmf.org_payment_method_name
104: from hr_all_organization_units hou,
105: --hr_organization_information hoi, --15971893
106: pay_org_payment_methods_f popmf,
107: PAY_ORG_PAY_METHOD_USAGES_F popmu,
108: PAY_ALL_PAYROLLS_F papf,