DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_TEMP_OBJECT_ACTIONS

Line 2041: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;

2037:
2038: l_person_id per_all_people_f.person_id%TYPE;
2039: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2040: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2041: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
2042:
2043: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
2044: SELECT DISTINCT ppf.person_id, paa.assignment_id
2045: FROM per_all_people_f ppf

Line 2048: ,pay_temp_object_actions ptoa

2044: SELECT DISTINCT ppf.person_id, paa.assignment_id
2045: FROM per_all_people_f ppf
2046: ,per_all_assignments_f paa
2047: ,pay_payroll_actions ppa
2048: ,pay_temp_object_actions ptoa
2049: WHERE paa.business_group_id = ppa.business_group_id
2050: AND paa.person_id = ppf.person_id
2051: AND ppa.payroll_action_id = p_payroll_action_id
2052: AND paa.business_group_id = g_business_Group_id