DBA Data[Home] [Help]

APPS.PAY_DK_GENERAL dependencies on PAY_PAYROLL_ACTIONS

Line 224: ,PAY_PAYROLL_ACTIONS ppa

220: SELECT hoi2.org_information1 cvr_number
221: FROM HR_ORGANIZATION_INFORMATION hoi1
222: ,HR_ORGANIZATION_INFORMATION hoi2
223: ,HR_ORGANIZATION_UNITS hou
224: ,PAY_PAYROLL_ACTIONS ppa
225: WHERE ppa.payroll_action_id = p_payroll_action_id
226: and hoi1.org_information_context ='CLASS'
227: and hoi1.org_information1 ='DK_SERVICE_PROVIDER'
228: and hoi1.ORG_INFORMATION2 ='Y'

Line 637: FROM pay_payroll_actions ppa

633: ) RETURN VARCHAR2 IS
634:
635: CURSOR cur_table_val_exist_400(p_payroll_action_id number) IS
636: SELECT 'Y'
637: FROM pay_payroll_actions ppa
638: , pay_user_tables put
639: , pay_user_columns puc
640: , pay_user_column_instances_f puci
641: , pay_user_rows_f pur