APPS.CREATE_GB_RTI_EPS_RECORD dependencies on PAY_PAYROLL_ACTIONS

Line 211: pay_payroll_actions pact

207: || paa.assignment_action_id),16)) lat_assignment_action_id,
208: MAX(pact.effective_date) effective_date,
209: paa.assignment_id
210: FROM pay_assignment_actions paa,
211: pay_payroll_actions pact
212: WHERE paa.payroll_action_id = pact.payroll_action_id
213: AND pact.action_type IN ('Q','R','B','I','V')
214: AND paa.action_status IN ('C','S')
215: AND pact.effective_date BETWEEN l_date_soy AND l_eff_start_date

Line 465: select effective_date into l_eff_date from pay_assignment_actions paa, pay_payroll_actions ppa where ppa.payroll_action_id = paa.payroll_action_id

461: fnd_file.put_line(fnd_file.LOG,'Pamount:' || p_amount );
462: fnd_file.put_line(fnd_file.LOG,'p_element_type_id:' || p_element_type_id);
463: fnd_file.put_line(fnd_file.LOG,'p_assignment_action_id:' || p_assignment_action_id);
464:
465: select effective_date into l_eff_date from pay_assignment_actions paa, pay_payroll_actions ppa where ppa.payroll_action_id = paa.payroll_action_id
466: and paa.assignment_action_id = p_assignment_action_id;
467:
468: select business_group_id, payroll_id into g_business_group_id , l_payroll_id
469: from pay_payroll_Actions ppa,

Line 469: from pay_payroll_Actions ppa,

465: select effective_date into l_eff_date from pay_assignment_actions paa, pay_payroll_actions ppa where ppa.payroll_action_id = paa.payroll_action_id
466: and paa.assignment_action_id = p_assignment_action_id;
467:
468: select business_group_id, payroll_id into g_business_group_id , l_payroll_id
469: from pay_payroll_Actions ppa,
470: pay_assignment_Actions paa
471: where paa.PAYROLL_ACTION_ID = ppa.payroll_Action_id
472: and paa.assignment_action_id = p_assignment_action_id;
473: