DBA Data[Home] [Help]

APPS.PAY_SG_AWCAP_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 272: c_business_group_id hr_organization_units.business_group_id%type,

268: from per_people_f people1
269: where people1.person_id = pap.person_id);
270: --
271: cursor month_year_action_sequence ( c_person_id per_all_people_f.person_id%type,
272: c_business_group_id hr_organization_units.business_group_id%type,
273: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
274: c_basis_year varchar2 )
275: is
276: select /*+ ORDERED USE_NL(pacmax) */

Line 294: c_business_group_id hr_organization_units.business_group_id%type,

290: group by to_char(ppamax.effective_date,'MM')
291: order by to_char(ppamax.effective_date,'MM') desc;
292: --
293: cursor month_year_action ( c_person_id per_all_people_f.person_id%type,
294: c_business_group_id hr_organization_units.business_group_id%type,
295: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
296: c_basis_year varchar2,
297: c_action_sequence pay_assignment_actions.action_sequence%type )
298: is