eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 161: FROM per_all_assignments_f

157: AND trunc(sysdate) between per.effective_start_date and per.effective_end_date;
158:
159: CURSOR csr_emp_catg IS
160: SELECT employee_category
161: FROM per_all_assignments_f
162: WHERE person_id = p_person_id
163: AND p_determination_date between effective_start_date and effective_end_date;
164:
165: BEGIN

Line 206: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

202:
203:
204: FUNCTION get_absent_period (p_bg_id IN per_all_organization_units.organization_id%TYPE,
205: p_person_id IN per_all_people_f.person_id%TYPE,
206: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
207: p_los_type IN hr_lookups.lookup_code%TYPE,
208: p_start_date IN DATE,
209: p_end_date IN DATE
210: )

Line 289: FUNCTION get_parttime_entitlement(p_person_id IN per_all_assignments_f.person_id%TYPE,

285: -- This function returns the parttime entitlement defined for the
286: -- the assignment.
287: -- -----------------------------------------------------------------------*
288:
289: FUNCTION get_parttime_entitlement(p_person_id IN per_all_assignments_f.person_id%TYPE,
290: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
291: p_bg_id IN per_all_organization_units.organization_id%TYPE,
292: p_los_type IN hr_lookups.lookup_code%TYPE,
293: p_start_date IN DATE,

Line 290: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

286: -- the assignment.
287: -- -----------------------------------------------------------------------*
288:
289: FUNCTION get_parttime_entitlement(p_person_id IN per_all_assignments_f.person_id%TYPE,
290: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
291: p_bg_id IN per_all_organization_units.organization_id%TYPE,
292: p_los_type IN hr_lookups.lookup_code%TYPE,
293: p_start_date IN DATE,
294: p_end_date IN DATE)

Line 315: FROM per_all_assignments_f asg

311: asg.effective_start_date,
312: asg.effective_end_date,
313: NVL(asg.normal_hours,0) NORMAL_HOURS,
314: asg.frequency
315: FROM per_all_assignments_f asg
316: WHERE asg.assignment_id = p_assignment_id
317: AND (p_end_date BETWEEN asg.effective_start_date AND asg.effective_end_date
318: OR p_start_date BETWEEN asg.effective_start_date AND asg.effective_end_date);
319:

Line 474: per_all_assignments_f paf,

470: cursor cur_corps is
471: select to_number(hsck.segment7) corps_id
472: from hr_soft_coding_keyflex hsck,
473: fnd_id_flex_structures fifs,
474: per_all_assignments_f paf,
475: per_all_people_f ppf
476: where hsck.id_flex_num = fifs.id_flex_num
477: and fifs.id_flex_structure_code = 'FR_STATUTORY_INFO.'
478: and fifs.application_id = 800

Line 488: per_all_assignments_f

484: and ppf.person_id = l_person_id;
485:
486: cursor cur_grade is
487: select grade_id from
488: per_all_assignments_f
489: where person_id = l_person_id
490: and
491: primary_flag = 'Y'
492: and

Line 497: per_all_assignments_f

493: sysdate between effective_start_date and effective_end_date;
494:
495: cursor cur_step is
496: select special_ceiling_step_id from
497: per_all_assignments_f
498: where person_id = l_person_id
499: and
500: primary_flag = 'Y'
501: and

Line 506: per_all_assignments_f

502: sysdate between effective_start_date and effective_end_date;
503:
504: cursor cur_position is
505: select position_id from
506: per_all_assignments_f
507: where person_id = l_person_id
508: and
509: primary_flag = 'Y'
510: and

Line 684: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

680: -- -----------------------------------------------------------------------*
681:
682: FUNCTION get_gen_pub_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,
683: p_person_id IN per_all_people_f.person_id%TYPE,
684: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
685: p_los_type IN VARCHAR2,
686: p_determination_date IN DATE)
687: RETURN NUMBER IS
688: /*

Line 691: FROM per_all_assignments_f

687: RETURN NUMBER IS
688: /*
689: CURSOR csr_asg_period IS
690: SELECT Min(effective_start_date)
691: FROM per_all_assignments_f
692: WHERE person_id = p_person_id
693: AND assignment_id = p_assignment_id;
694:
695: */

Line 781: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

777: -- -----------------------------------------------------------------------*
778:
779: FUNCTION get_grade_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
780: p_person_id IN per_all_people_f.person_id%TYPE,
781: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
782: p_determination_date IN DATE)
783: RETURN NUMBER IS
784:
785:

Line 789: FROM per_all_assignments_f asg

785:
786: CURSOR csr_asg_grade IS
787: SELECT asg.assignment_id,
788: asg.grade_id
789: FROM per_all_assignments_f asg
790: WHERE asg.person_id = p_person_id
791: AND (p_assignment_id IS NOT NULL OR asg.primary_flag ='Y')
792: AND (p_assignment_id IS NULL OR asg.assignment_id = p_assignment_id)
793: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 803: FROM per_all_assignments_f asg

799:
800: CURSOR csr_grade_period IS
801: SELECT asg.effective_start_date,
802: asg.effective_end_date
803: FROM per_all_assignments_f asg
804: WHERE asg.assignment_id = l_assignment_id
805: AND asg.grade_id = l_grade_id
806: AND asg.effective_start_date <= p_determination_date
807: ORDER BY asg.effective_start_date, asg.effective_end_date;

Line 894: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

890: -- -----------------------------------------------------------------------*
891:
892: FUNCTION get_position_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
893: p_person_id IN per_all_people_f.person_id%TYPE,
894: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
895: p_determination_date IN DATE)
896: RETURN NUMBER IS
897:
898:

Line 904: FROM per_all_assignments_f asg

900:
901: CURSOR csr_asg_position IS
902: SELECT asg.assignment_id,
903: asg.position_id
904: FROM per_all_assignments_f asg
905: WHERE asg.person_id = p_person_id
906: AND (p_assignment_id IS NOT NULL OR asg.primary_flag ='Y')
907: AND (p_assignment_id IS NULL OR asg.assignment_id = p_assignment_id)
908: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 915: FROM per_all_assignments_f asg

911:
912: CURSOR csr_position_period IS
913: SELECT asg.effective_start_date,
914: asg.effective_end_date
915: FROM per_all_assignments_f asg
916: WHERE asg.assignment_id = l_assignment_id
917: AND asg.position_id = l_position_id
918: AND asg.effective_start_date <= p_determination_date
919: ORDER BY asg.effective_start_date, asg.effective_end_date;

Line 1006: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1002: -- -----------------------------------------------------------------------*
1003:
1004: FUNCTION get_corps_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
1005: p_person_id IN per_all_people_f.person_id%TYPE,
1006: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1007: p_determination_date IN DATE)
1008: RETURN NUMBER IS
1009:
1010:

Line 1016: FROM per_all_assignments_f asg

1012:
1013: CURSOR csr_asg_corps
1014: IS
1015: SELECT asg.assignment_id, grade_ladder_pgm_id
1016: FROM per_all_assignments_f asg
1017: WHERE asg.person_id = p_person_id
1018: AND (p_assignment_id IS NOT NULL OR asg.primary_flag = 'Y')
1019: AND (p_assignment_id IS NULL
1020: OR asg.assignment_id = p_assignment_id

Line 1032: FROM per_all_assignments_f asg

1028:
1029: CURSOR csr_corps_period
1030: IS
1031: SELECT asg.effective_start_date, asg.effective_end_date
1032: FROM per_all_assignments_f asg
1033: WHERE asg.assignment_id = l_assignment_id
1034: AND asg.effective_start_date <= p_determination_date
1035: AND asg.grade_ladder_pgm_id = l_corps_id;
1036:

Line 1122: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1118: -- -----------------------------------------------------------------------*
1119:
1120: FUNCTION get_step_length_of_service (p_bg_id IN per_all_organization_units.organization_id%TYPE,
1121: p_person_id IN per_all_people_f.person_id%TYPE,
1122: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1123: p_determination_date IN DATE)
1124: RETURN NUMBER IS
1125: Cursor Csr_asg_step IS
1126: SELECT spp.assignment_id,

Line 1130: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg

1126: SELECT spp.assignment_id,
1127: spp.step_id,
1128: spp.effective_start_date,
1129: spp.effective_end_date
1130: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg
1131: WHERE asg.person_id = p_person_id
1132: AND (p_assignment_id IS NOT NULL OR asg.primary_flag = 'Y')
1133: AND (p_assignment_id IS NULL OR asg.assignment_id = p_assignment_id)
1134: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 1281: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;

1277: IS
1278:
1279: l_start_date DATE;
1280: l_determination_date DATE := p_determination_date;
1281: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1282: l_los_days NUMBER(22,3) := 0;
1283: l_los_return NUMBER(22,3);
1284: l_emp_type PER_ALL_ASSIGNMENTS_F.employee_category%TYPE;
1285: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;

Line 1284: l_emp_type PER_ALL_ASSIGNMENTS_F.employee_category%TYPE;

1280: l_determination_date DATE := p_determination_date;
1281: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1282: l_los_days NUMBER(22,3) := 0;
1283: l_los_return NUMBER(22,3);
1284: l_emp_type PER_ALL_ASSIGNMENTS_F.employee_category%TYPE;
1285: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
1286: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;
1287: l_adj_service_date DATE;
1288: l_proc varchar2(60) := g_package||'get_length_of_sevice';

Line 1299: FROM per_all_assignments_f

1295: AND l_determination_date BETWEEN effective_start_date AND effective_end_date;
1296:
1297: CURSOR CSR_validate_assignment IS
1298: SELECT person_id
1299: FROM per_all_assignments_f
1300: WHERE assignment_id = p_assignment_id
1301: AND l_determination_date BETWEEN effective_start_date AND effective_end_date;
1302: CURSOR Csr_get_primary_asg IS
1303: SELECT assignment_id

Line 1304: FROM per_all_assignments_f

1300: WHERE assignment_id = p_assignment_id
1301: AND l_determination_date BETWEEN effective_start_date AND effective_end_date;
1302: CURSOR Csr_get_primary_asg IS
1303: SELECT assignment_id
1304: FROM per_all_assignments_f
1305: WHERE person_id = p_person_id
1306: AND primary_flag = 'Y'
1307: AND l_determination_date BETWEEN effective_start_date AND effective_end_date;
1308:

Line 1551: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1547: -- -----------------------------------------------------------------------*
1548:
1549: FUNCTION get_de_pub_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
1550: p_person_id IN per_all_people_f.person_id%TYPE,
1551: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1552: p_los_type IN VARCHAR2,
1553: p_assg_start_date IN DATE ,
1554: p_assg_end_date IN DATE
1555: )

Line 1666: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1662: -- -----------------------------------------------------------------------*
1663:
1664: FUNCTION get_jub_mon_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
1665: p_person_id IN per_all_people_f.person_id%TYPE,
1666: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1667: p_los_type IN VARCHAR2,
1668: p_assg_start_date IN DATE ,
1669: p_assg_end_date IN DATE
1670: )

Line 1684: l_emp_type per_all_assignments_f.employee_category%TYPE;

1680: l_date_of_birth DATE;
1681: l_per_los_flag per_all_people_f.per_information10%TYPE;
1682: l_assg_los_type varchar2(1);
1683: l_entitlement pqh_situations.entitlement_value%TYPE :=0;
1684: l_emp_type per_all_assignments_f.employee_category%TYPE;
1685:
1686:
1687: CURSOR c_person_dob IS
1688: SELECT date_of_birth, nvl(per_information10,'N')

Line 1802: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1798: -- -----------------------------------------------------------------------*
1799:
1800: FUNCTION get_bda_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
1801: p_person_id IN per_all_people_f.person_id%TYPE,
1802: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1803: p_los_type IN VARCHAR2,
1804: p_assg_start_date IN DATE ,
1805: p_assg_end_date IN DATE
1806: )

Line 1811: FROM per_all_assignments_f

1807: RETURN NUMBER IS
1808:
1809: CURSOR c_assg_emp_catg IS
1810: SELECT employee_category, position_id
1811: FROM per_all_assignments_f
1812: WHERE person_id = p_person_id
1813: AND assignment_id = p_assignment_id
1814: AND effective_start_date = p_assg_start_date
1815: AND effective_end_date = decode(p_assg_end_date,trunc(sysdate),effective_end_date,p_assg_end_date);

Line 1824: CURSOR c_tariff_contract(p_position_id per_all_assignments_f.position_id%type) IS

1820: WHERE person_id = p_person_id
1821: AND effective_start_date <= p_assg_end_date
1822: AND effective_end_date >= p_assg_start_date;
1823:
1824: CURSOR c_tariff_contract(p_position_id per_all_assignments_f.position_id%type) IS
1825: SELECT wkvr.tariff_contract_code
1826: FROM hr_all_positions_f pos, pqh_de_wrkplc_vldtn_vers wkvr
1827: WHERE pos.position_id = p_position_id
1828: AND pos.information1='WP'

Line 1840: l_employee_category per_all_assignments_f.employee_category%TYPE;

1836: WHERE assignment_id = p_assignment_id
1837: AND nvl(aei_information1,'x') = p_los_type
1838: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
1839:
1840: l_employee_category per_all_assignments_f.employee_category%TYPE;
1841: l_position_id per_all_assignments_f.position_id%TYPE;
1842: l_tariff_contract_code pqh_de_wrkplc_vldtn_vers.tariff_contract_code%TYPE;
1843: l_date_of_birth DATE;
1844: l_dob_21 DATE;

Line 1841: l_position_id per_all_assignments_f.position_id%TYPE;

1837: AND nvl(aei_information1,'x') = p_los_type
1838: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
1839:
1840: l_employee_category per_all_assignments_f.employee_category%TYPE;
1841: l_position_id per_all_assignments_f.position_id%TYPE;
1842: l_tariff_contract_code pqh_de_wrkplc_vldtn_vers.tariff_contract_code%TYPE;
1843: l_date_of_birth DATE;
1844: l_dob_21 DATE;
1845: l_dob_31 DATE;

Line 1984: FROM per_all_assignments_f asg

1980: RETURN NUMBER IS
1981:
1982: CURSOR c_curr_grade IS
1983: SELECT grade_id
1984: FROM per_all_assignments_f asg
1985: WHERE asg.person_id = p_person_id
1986: AND trunc(sysdate) between effective_start_date and effective_end_date;
1987:
1988: l_curr_grade_id per_assignments_f.grade_id%TYPE;

Line 2008: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

2004: --
2005:
2006: FUNCTION get_de_grade_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
2007: p_person_id IN per_all_people_f.person_id%TYPE,
2008: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2009: p_los_type IN VARCHAR2,
2010: p_assg_start_date IN DATE ,
2011: p_assg_end_date IN DATE
2012: )

Line 2018: FROM per_all_assignments_f asg

2014:
2015:
2016: CURSOR csr_asg_grade IS
2017: SELECT asg.grade_id
2018: FROM per_all_assignments_f asg
2019: WHERE asg.person_id = p_person_id
2020: AND asg.assignment_id = p_assignment_id
2021: AND asg.effective_start_date = p_assg_start_date
2022: AND asg.effective_end_date = decode(p_assg_end_date,trunc(sysdate),asg.effective_end_date,p_assg_end_date);

Line 2026: FROM per_all_assignments_f asg

2022: AND asg.effective_end_date = decode(p_assg_end_date,trunc(sysdate),asg.effective_end_date,p_assg_end_date);
2023:
2024: CURSOR c_curr_grade IS
2025: SELECT grade_id
2026: FROM per_all_assignments_f asg
2027: WHERE asg.person_id = p_person_id
2028: AND trunc(sysdate) between effective_start_date and effective_end_date;
2029:
2030: CURSOR c_assg_los_type IS

Line 2119: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg

2115: RETURN NUMBER IS
2116:
2117: Cursor c_current_step IS
2118: SELECT spp.step_id
2119: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg
2120: WHERE asg.person_id = p_person_id
2121: AND spp.assignment_id = asg.assignment_id
2122: AND trunc(sysdate) BETWEEN spp.effective_start_date and spp.effective_end_date;
2123:

Line 2141: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

2137: -- -----------------------------------------------------------------------*
2138:
2139: FUNCTION get_de_step_length_of_service (p_bg_id IN per_all_organization_units.organization_id%TYPE,
2140: p_person_id IN per_all_people_f.person_id%TYPE,
2141: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2142: p_los_type IN VARCHAR2,
2143: p_assg_start_date IN DATE ,
2144: p_assg_end_date IN DATE
2145: )

Line 2151: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg

2147: Cursor Csr_asg_step IS
2148: SELECT spp.step_id,
2149: spp.effective_start_date,
2150: spp.effective_end_date
2151: FROM per_spinal_point_placements_f spp, per_all_assignments_f asg
2152: WHERE asg.person_id = p_person_id
2153: AND asg.assignment_id = p_assignment_id
2154: AND spp.assignment_id = asg.assignment_id
2155: AND p_assg_end_date BETWEEN spp.effective_start_date and spp.effective_end_date;

Line 2271: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

2267: -- -----------------------------------------------------------------------*
2268:
2269: FUNCTION get_de_assg_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,
2270: p_person_id IN per_all_people_f.person_id%TYPE,
2271: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2272: p_los_type IN VARCHAR2,
2273: p_assg_start_date IN DATE ,
2274: p_assg_end_date IN DATE)
2275: RETURN NUMBER IS

Line 2344: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL,

2340: --
2341:
2342: FUNCTION get_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,
2343: p_person_id IN per_all_people_f.person_id%TYPE,
2344: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL,
2345: p_prev_job_id IN per_previous_jobs.previous_job_id%TYPE DEFAULT NULL,
2346: p_los_type IN VARCHAR2,
2347: p_assg_start_date IN DATE ,
2348: p_assg_end_date IN DATE

Line 2371: l_assignment_id per_all_assignments_f.assignment_id%TYPE := p_assignment_id;

2367: l_prev_empl_id per_previous_employers.previous_employer_id%TYPE;
2368: l_person_id per_all_people_f.person_id%TYPE;
2369: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;
2370: l_entitlement pqh_situations.entitlement_value%TYPE :=0;
2371: l_assignment_id per_all_assignments_f.assignment_id%TYPE := p_assignment_id;
2372: l_proc VARCHAR2(60) := g_package||'get_length_of_service';
2373: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2374:
2375: CURSOR CSR_validate_person IS

Line 2373: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

2369: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;
2370: l_entitlement pqh_situations.entitlement_value%TYPE :=0;
2371: l_assignment_id per_all_assignments_f.assignment_id%TYPE := p_assignment_id;
2372: l_proc VARCHAR2(60) := g_package||'get_length_of_service';
2373: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2374:
2375: CURSOR CSR_validate_person IS
2376: SELECT '1'
2377: FROM per_all_people_f

Line 2384: FROM per_all_assignments_f

2380: or l_end_date BETWEEN effective_start_date AND effective_end_date);
2381:
2382: CURSOR CSR_validate_assignment IS
2383: SELECT person_id, primary_flag
2384: FROM per_all_assignments_f
2385: WHERE assignment_id = p_assignment_id
2386: AND (p_assg_start_date BETWEEN effective_start_date AND effective_end_date
2387: or l_end_date BETWEEN effective_start_date AND effective_end_date);
2388:

Line 2675: FUNCTION get_corps_name (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

2671: RETURN (nvl(l_correction_factor,'0'));
2672:
2673: END get_de_correction_factor;
2674:
2675: FUNCTION get_corps_name (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2676: p_bg_id IN per_all_organization_units.organization_id%TYPE)
2677: RETURN VARCHAR2 IS
2678:
2679: cursor csr_corps is

Line 2685: (select soft_coding_keyflex_id from per_all_assignments_f where

2681: (select id_flex_num from fnd_id_flex_structures fifs
2682: where id_flex_structure_code = 'FR_STATUTORY_INFO.'
2683: and fifs.application_id = 800 and fifs.id_flex_code = 'SCL')
2684: and soft_coding_keyflex_id in
2685: (select soft_coding_keyflex_id from per_all_assignments_f where
2686: assignment_id = p_assignment_id
2687: and business_group_id = p_bg_id);
2688: l_corps_id number(20);
2689: l_corps_name varchar2(100);