DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4712: ,c_business_group_id hr_all_organization_units.organization_id%TYPE

4708: ----------------------------------------------------------------------------------------+
4709: --
4710: cursor c_max_asg_action_id
4711: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
4712: ,c_business_group_id hr_all_organization_units.organization_id%TYPE
4713: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE
4714: ,c_year_start date
4715: ,c_year_end date
4716: ) is

Line 4713: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE

4709: --
4710: cursor c_max_asg_action_id
4711: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
4712: ,c_business_group_id hr_all_organization_units.organization_id%TYPE
4713: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE
4714: ,c_year_start date
4715: ,c_year_end date
4716: ) is
4717: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id,