APPS.PAY_FR_DADS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 78: from pay_assignment_Actions paa_run

74: index(org_coy HR_ORGANIZATION_INFORMATIO_FK2) */
75: ppa_run.payroll_id, asg_run.assignment_id,
76: max(nvl(paa_run.source_action_id
77: ,paa_run.assignment_action_id)) mst_action_id
78: from pay_assignment_Actions paa_run
79: ,pay_payroll_actions ppa_run
80: ,per_all_assignments_f asg_run
81: ,hr_organization_information org_est
82: ,hr_organization_information org_coy

Line 113: l_actid pay_assignment_actions.assignment_action_id%TYPE;

109:
110: --
111: l_qualify_asg_rec csr_qualifying_assignments%ROWTYPE;
112: --
113: l_actid pay_assignment_actions.assignment_action_id%TYPE;
114: --
115: BEGIN
116: hr_utility.set_location('Entering ' || l_proc,20);
117: --

Line 144: SELECT pay_assignment_actions_s.NEXTVAL

140: -- get the latest master action in the period and lock it
141: --
142: -- create a new action and lock the fetched one
143: --
144: SELECT pay_assignment_actions_s.NEXTVAL
145: INTO l_actid
146: FROM dual;
147: --
148: hr_nonrun_asact.insact(l_actid

Line 344: pay_assignment_actions pasac

340: -- from archived assignments
341: cursor S80 is
342: select distinct pacinfo.action_information7 estab_id
343: from pay_action_information pacinfo,
344: pay_assignment_actions pasac
345: where pacinfo.action_context_id = pasac.assignment_action_id
346: and pasac.payroll_action_id = p_payroll_action_id
347: and pacinfo.action_information_category = 'FR_DADS_FILE_DATA'
348: and pacinfo.action_information1 = 'S41.G01.00.005';