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.BEN_PD_COPY_TO_BEN_FOUR dependencies on PQH_COPY_ENTITY_ATTRIBS

Line 321: l_prefix pqh_copy_entity_attribs.information1%type := null;

317: l_elig_asnt_set_prte_id number ;
318: l_object_version_number number ;
319: l_effective_start_date date ;
320: l_effective_end_date date ;
321: l_prefix pqh_copy_entity_attribs.information1%type := null;
322: l_suffix pqh_copy_entity_attribs.information1%type := null;
323: l_new_value number(15);
324: l_object_found_in_target boolean := false ;
325: l_min_esd date;

Line 322: l_suffix pqh_copy_entity_attribs.information1%type := null;

318: l_object_version_number number ;
319: l_effective_start_date date ;
320: l_effective_end_date date ;
321: l_prefix pqh_copy_entity_attribs.information1%type := null;
322: l_suffix pqh_copy_entity_attribs.information1%type := null;
323: l_new_value number(15);
324: l_object_found_in_target boolean := false ;
325: l_min_esd date;
326: l_max_eed date;

Line 861: l_prefix pqh_copy_entity_attribs.information1%type := null;

857: l_cntng_prtn_elig_prfl_id number ;
858: l_object_version_number number ;
859: l_effective_start_date date ;
860: l_effective_end_date date ;
861: l_prefix pqh_copy_entity_attribs.information1%type := null;
862: l_suffix pqh_copy_entity_attribs.information1%type := null;
863: l_new_value number(15);
864: l_object_found_in_target boolean := false ;
865: l_min_esd date;

Line 862: l_suffix pqh_copy_entity_attribs.information1%type := null;

858: l_object_version_number number ;
859: l_effective_start_date date ;
860: l_effective_end_date date ;
861: l_prefix pqh_copy_entity_attribs.information1%type := null;
862: l_suffix pqh_copy_entity_attribs.information1%type := null;
863: l_new_value number(15);
864: l_object_found_in_target boolean := false ;
865: l_min_esd date;
866: l_max_eed date;

Line 1356: l_prefix pqh_copy_entity_attribs.information1%type := null;

1352: l_elig_age_prte_id number ;
1353: l_object_version_number number ;
1354: l_effective_start_date date ;
1355: l_effective_end_date date ;
1356: l_prefix pqh_copy_entity_attribs.information1%type := null;
1357: l_suffix pqh_copy_entity_attribs.information1%type := null;
1358: l_new_value number(15);
1359: l_object_found_in_target boolean := false ;
1360: l_min_esd date;

Line 1357: l_suffix pqh_copy_entity_attribs.information1%type := null;

1353: l_object_version_number number ;
1354: l_effective_start_date date ;
1355: l_effective_end_date date ;
1356: l_prefix pqh_copy_entity_attribs.information1%type := null;
1357: l_suffix pqh_copy_entity_attribs.information1%type := null;
1358: l_new_value number(15);
1359: l_object_found_in_target boolean := false ;
1360: l_min_esd date;
1361: l_max_eed date;

Line 1847: l_prefix pqh_copy_entity_attribs.information1%type := null;

1843: l_elig_benfts_grp_prte_id number ;
1844: l_object_version_number number ;
1845: l_effective_start_date date ;
1846: l_effective_end_date date ;
1847: l_prefix pqh_copy_entity_attribs.information1%type := null;
1848: l_suffix pqh_copy_entity_attribs.information1%type := null;
1849: l_new_value number(15);
1850: l_object_found_in_target boolean := false ;
1851: l_min_esd date;

Line 1848: l_suffix pqh_copy_entity_attribs.information1%type := null;

1844: l_object_version_number number ;
1845: l_effective_start_date date ;
1846: l_effective_end_date date ;
1847: l_prefix pqh_copy_entity_attribs.information1%type := null;
1848: l_suffix pqh_copy_entity_attribs.information1%type := null;
1849: l_new_value number(15);
1850: l_object_found_in_target boolean := false ;
1851: l_min_esd date;
1852: l_max_eed date;

Line 2338: l_prefix pqh_copy_entity_attribs.information1%type := null;

2334: l_elig_brgng_unit_prte_id number ;
2335: l_object_version_number number ;
2336: l_effective_start_date date ;
2337: l_effective_end_date date ;
2338: l_prefix pqh_copy_entity_attribs.information1%type := null;
2339: l_suffix pqh_copy_entity_attribs.information1%type := null;
2340: l_new_value number(15);
2341: l_object_found_in_target boolean := false ;
2342: l_min_esd date;

Line 2339: l_suffix pqh_copy_entity_attribs.information1%type := null;

2335: l_object_version_number number ;
2336: l_effective_start_date date ;
2337: l_effective_end_date date ;
2338: l_prefix pqh_copy_entity_attribs.information1%type := null;
2339: l_suffix pqh_copy_entity_attribs.information1%type := null;
2340: l_new_value number(15);
2341: l_object_found_in_target boolean := false ;
2342: l_min_esd date;
2343: l_max_eed date;

Line 2830: l_prefix pqh_copy_entity_attribs.information1%type := null;

2826: l_elig_comp_lvl_prte_id number ;
2827: l_object_version_number number ;
2828: l_effective_start_date date ;
2829: l_effective_end_date date ;
2830: l_prefix pqh_copy_entity_attribs.information1%type := null;
2831: l_suffix pqh_copy_entity_attribs.information1%type := null;
2832: l_new_value number(15);
2833: l_object_found_in_target boolean := false ;
2834: l_min_esd date;

Line 2831: l_suffix pqh_copy_entity_attribs.information1%type := null;

2827: l_object_version_number number ;
2828: l_effective_start_date date ;
2829: l_effective_end_date date ;
2830: l_prefix pqh_copy_entity_attribs.information1%type := null;
2831: l_suffix pqh_copy_entity_attribs.information1%type := null;
2832: l_new_value number(15);
2833: l_object_found_in_target boolean := false ;
2834: l_min_esd date;
2835: l_max_eed date;

Line 3320: l_prefix pqh_copy_entity_attribs.information1%type := null;

3316: l_elig_cmbn_age_los_prte_id number ;
3317: l_object_version_number number ;
3318: l_effective_start_date date ;
3319: l_effective_end_date date ;
3320: l_prefix pqh_copy_entity_attribs.information1%type := null;
3321: l_suffix pqh_copy_entity_attribs.information1%type := null;
3322: l_new_value number(15);
3323: l_object_found_in_target boolean := false ;
3324: l_min_esd date;

Line 3321: l_suffix pqh_copy_entity_attribs.information1%type := null;

3317: l_object_version_number number ;
3318: l_effective_start_date date ;
3319: l_effective_end_date date ;
3320: l_prefix pqh_copy_entity_attribs.information1%type := null;
3321: l_suffix pqh_copy_entity_attribs.information1%type := null;
3322: l_new_value number(15);
3323: l_object_found_in_target boolean := false ;
3324: l_min_esd date;
3325: l_max_eed date;

Line 3819: l_prefix pqh_copy_entity_attribs.information1%type := null;

3815: l_elig_cbr_quald_bnf_id number ;
3816: l_object_version_number number ;
3817: l_effective_start_date date ;
3818: l_effective_end_date date ;
3819: l_prefix pqh_copy_entity_attribs.information1%type := null;
3820: l_suffix pqh_copy_entity_attribs.information1%type := null;
3821: l_new_value number(15);
3822: l_object_found_in_target boolean := false ;
3823: l_min_esd date;

Line 3820: l_suffix pqh_copy_entity_attribs.information1%type := null;

3816: l_object_version_number number ;
3817: l_effective_start_date date ;
3818: l_effective_end_date date ;
3819: l_prefix pqh_copy_entity_attribs.information1%type := null;
3820: l_suffix pqh_copy_entity_attribs.information1%type := null;
3821: l_new_value number(15);
3822: l_object_found_in_target boolean := false ;
3823: l_min_esd date;
3824: l_max_eed date;

Line 4330: l_prefix pqh_copy_entity_attribs.information1%type := null;

4326: l_elig_comptncy_prte_id number ;
4327: l_object_version_number number ;
4328: l_effective_start_date date ;
4329: l_effective_end_date date ;
4330: l_prefix pqh_copy_entity_attribs.information1%type := null;
4331: l_suffix pqh_copy_entity_attribs.information1%type := null;
4332: l_new_value number(15);
4333: l_object_found_in_target boolean := false ;
4334: l_min_esd date;

Line 4331: l_suffix pqh_copy_entity_attribs.information1%type := null;

4327: l_object_version_number number ;
4328: l_effective_start_date date ;
4329: l_effective_end_date date ;
4330: l_prefix pqh_copy_entity_attribs.information1%type := null;
4331: l_suffix pqh_copy_entity_attribs.information1%type := null;
4332: l_new_value number(15);
4333: l_object_found_in_target boolean := false ;
4334: l_min_esd date;
4335: l_max_eed date;

Line 4951: l_prefix pqh_copy_entity_attribs.information1%type := null;

4947: l_elig_dpnt_cvrd_othr_pgm_id number ;
4948: l_object_version_number number ;
4949: l_effective_start_date date ;
4950: l_effective_end_date date ;
4951: l_prefix pqh_copy_entity_attribs.information1%type := null;
4952: l_suffix pqh_copy_entity_attribs.information1%type := null;
4953: l_new_value number(15);
4954: l_object_found_in_target boolean := false ;
4955: l_min_esd date;

Line 4952: l_suffix pqh_copy_entity_attribs.information1%type := null;

4948: l_object_version_number number ;
4949: l_effective_start_date date ;
4950: l_effective_end_date date ;
4951: l_prefix pqh_copy_entity_attribs.information1%type := null;
4952: l_suffix pqh_copy_entity_attribs.information1%type := null;
4953: l_new_value number(15);
4954: l_object_found_in_target boolean := false ;
4955: l_min_esd date;
4956: l_max_eed date;

Line 5454: l_prefix pqh_copy_entity_attribs.information1%type := null;

5450: l_elig_dpnt_cvrd_plip_id number ;
5451: l_object_version_number number ;
5452: l_effective_start_date date ;
5453: l_effective_end_date date ;
5454: l_prefix pqh_copy_entity_attribs.information1%type := null;
5455: l_suffix pqh_copy_entity_attribs.information1%type := null;
5456: l_new_value number(15);
5457: l_object_found_in_target boolean := false ;
5458: l_min_esd date;

Line 5455: l_suffix pqh_copy_entity_attribs.information1%type := null;

5451: l_object_version_number number ;
5452: l_effective_start_date date ;
5453: l_effective_end_date date ;
5454: l_prefix pqh_copy_entity_attribs.information1%type := null;
5455: l_suffix pqh_copy_entity_attribs.information1%type := null;
5456: l_new_value number(15);
5457: l_object_found_in_target boolean := false ;
5458: l_min_esd date;
5459: l_max_eed date;

Line 5957: l_prefix pqh_copy_entity_attribs.information1%type := null;

5953: l_elig_dpnt_cvrd_othr_pl_id number ;
5954: l_object_version_number number ;
5955: l_effective_start_date date ;
5956: l_effective_end_date date ;
5957: l_prefix pqh_copy_entity_attribs.information1%type := null;
5958: l_suffix pqh_copy_entity_attribs.information1%type := null;
5959: l_new_value number(15);
5960: l_object_found_in_target boolean := false ;
5961: l_min_esd date;

Line 5958: l_suffix pqh_copy_entity_attribs.information1%type := null;

5954: l_object_version_number number ;
5955: l_effective_start_date date ;
5956: l_effective_end_date date ;
5957: l_prefix pqh_copy_entity_attribs.information1%type := null;
5958: l_suffix pqh_copy_entity_attribs.information1%type := null;
5959: l_new_value number(15);
5960: l_object_found_in_target boolean := false ;
5961: l_min_esd date;
5962: l_max_eed date;

Line 6456: l_prefix pqh_copy_entity_attribs.information1%type := null;

6452: l_elig_dpnt_cvrd_othr_ptip_id number ;
6453: l_object_version_number number ;
6454: l_effective_start_date date ;
6455: l_effective_end_date date ;
6456: l_prefix pqh_copy_entity_attribs.information1%type := null;
6457: l_suffix pqh_copy_entity_attribs.information1%type := null;
6458: l_new_value number(15);
6459: l_object_found_in_target boolean := false ;
6460: l_min_esd date;

Line 6457: l_suffix pqh_copy_entity_attribs.information1%type := null;

6453: l_object_version_number number ;
6454: l_effective_start_date date ;
6455: l_effective_end_date date ;
6456: l_prefix pqh_copy_entity_attribs.information1%type := null;
6457: l_suffix pqh_copy_entity_attribs.information1%type := null;
6458: l_new_value number(15);
6459: l_object_found_in_target boolean := false ;
6460: l_min_esd date;
6461: l_max_eed date;

Line 6956: l_prefix pqh_copy_entity_attribs.information1%type := null;

6952: l_eligy_prfl_rl_id number ;
6953: l_object_version_number number ;
6954: l_effective_start_date date ;
6955: l_effective_end_date date ;
6956: l_prefix pqh_copy_entity_attribs.information1%type := null;
6957: l_suffix pqh_copy_entity_attribs.information1%type := null;
6958: l_new_value number(15);
6959: l_object_found_in_target boolean := false ;
6960: l_min_esd date;

Line 6957: l_suffix pqh_copy_entity_attribs.information1%type := null;

6953: l_object_version_number number ;
6954: l_effective_start_date date ;
6955: l_effective_end_date date ;
6956: l_prefix pqh_copy_entity_attribs.information1%type := null;
6957: l_suffix pqh_copy_entity_attribs.information1%type := null;
6958: l_new_value number(15);
6959: l_object_found_in_target boolean := false ;
6960: l_min_esd date;
6961: l_max_eed date;

Line 7453: l_prefix pqh_copy_entity_attribs.information1%type := null;

7449: l_elig_hrs_wkd_prte_id number ;
7450: l_object_version_number number ;
7451: l_effective_start_date date ;
7452: l_effective_end_date date ;
7453: l_prefix pqh_copy_entity_attribs.information1%type := null;
7454: l_suffix pqh_copy_entity_attribs.information1%type := null;
7455: l_new_value number(15);
7456: l_object_found_in_target boolean := false ;
7457: l_min_esd date;

Line 7454: l_suffix pqh_copy_entity_attribs.information1%type := null;

7450: l_object_version_number number ;
7451: l_effective_start_date date ;
7452: l_effective_end_date date ;
7453: l_prefix pqh_copy_entity_attribs.information1%type := null;
7454: l_suffix pqh_copy_entity_attribs.information1%type := null;
7455: l_new_value number(15);
7456: l_object_found_in_target boolean := false ;
7457: l_min_esd date;
7458: l_max_eed date;

Line 7950: l_prefix pqh_copy_entity_attribs.information1%type := null;

7946: l_elig_job_prte_id number ;
7947: l_object_version_number number ;
7948: l_effective_start_date date ;
7949: l_effective_end_date date ;
7950: l_prefix pqh_copy_entity_attribs.information1%type := null;
7951: l_suffix pqh_copy_entity_attribs.information1%type := null;
7952: l_new_value number(15);
7953: l_object_found_in_target boolean := false ;
7954: l_min_esd date;

Line 7951: l_suffix pqh_copy_entity_attribs.information1%type := null;

7947: l_object_version_number number ;
7948: l_effective_start_date date ;
7949: l_effective_end_date date ;
7950: l_prefix pqh_copy_entity_attribs.information1%type := null;
7951: l_suffix pqh_copy_entity_attribs.information1%type := null;
7952: l_new_value number(15);
7953: l_object_found_in_target boolean := false ;
7954: l_min_esd date;
7955: l_max_eed date;

Line 8464: l_prefix pqh_copy_entity_attribs.information1%type := null;

8460: l_elig_lbr_mmbr_prte_id number ;
8461: l_object_version_number number ;
8462: l_effective_start_date date ;
8463: l_effective_end_date date ;
8464: l_prefix pqh_copy_entity_attribs.information1%type := null;
8465: l_suffix pqh_copy_entity_attribs.information1%type := null;
8466: l_new_value number(15);
8467: l_object_found_in_target boolean := false ;
8468: l_min_esd date;

Line 8465: l_suffix pqh_copy_entity_attribs.information1%type := null;

8461: l_object_version_number number ;
8462: l_effective_start_date date ;
8463: l_effective_end_date date ;
8464: l_prefix pqh_copy_entity_attribs.information1%type := null;
8465: l_suffix pqh_copy_entity_attribs.information1%type := null;
8466: l_new_value number(15);
8467: l_object_found_in_target boolean := false ;
8468: l_min_esd date;
8469: l_max_eed date;

Line 8953: l_prefix pqh_copy_entity_attribs.information1%type := null;

8949: l_elig_lgl_enty_prte_id number ;
8950: l_object_version_number number ;
8951: l_effective_start_date date ;
8952: l_effective_end_date date ;
8953: l_prefix pqh_copy_entity_attribs.information1%type := null;
8954: l_suffix pqh_copy_entity_attribs.information1%type := null;
8955: l_new_value number(15);
8956: l_object_found_in_target boolean := false ;
8957: l_min_esd date;

Line 8954: l_suffix pqh_copy_entity_attribs.information1%type := null;

8950: l_object_version_number number ;
8951: l_effective_start_date date ;
8952: l_effective_end_date date ;
8953: l_prefix pqh_copy_entity_attribs.information1%type := null;
8954: l_suffix pqh_copy_entity_attribs.information1%type := null;
8955: l_new_value number(15);
8956: l_object_found_in_target boolean := false ;
8957: l_min_esd date;
8958: l_max_eed date;

Line 9473: l_prefix pqh_copy_entity_attribs.information1%type := null;

9469: l_elig_loa_rsn_prte_id number ;
9470: l_object_version_number number ;
9471: l_effective_start_date date ;
9472: l_effective_end_date date ;
9473: l_prefix pqh_copy_entity_attribs.information1%type := null;
9474: l_suffix pqh_copy_entity_attribs.information1%type := null;
9475: l_new_value number(15);
9476: l_object_found_in_target boolean := false ;
9477: l_min_esd date;

Line 9474: l_suffix pqh_copy_entity_attribs.information1%type := null;

9470: l_object_version_number number ;
9471: l_effective_start_date date ;
9472: l_effective_end_date date ;
9473: l_prefix pqh_copy_entity_attribs.information1%type := null;
9474: l_suffix pqh_copy_entity_attribs.information1%type := null;
9475: l_new_value number(15);
9476: l_object_found_in_target boolean := false ;
9477: l_min_esd date;
9478: l_max_eed date;

Line 10024: l_prefix pqh_copy_entity_attribs.information1%type := null;

10020: l_elig_los_prte_id number ;
10021: l_object_version_number number ;
10022: l_effective_start_date date ;
10023: l_effective_end_date date ;
10024: l_prefix pqh_copy_entity_attribs.information1%type := null;
10025: l_suffix pqh_copy_entity_attribs.information1%type := null;
10026: l_new_value number(15);
10027: l_object_found_in_target boolean := false ;
10028: l_min_esd date;

Line 10025: l_suffix pqh_copy_entity_attribs.information1%type := null;

10021: l_object_version_number number ;
10022: l_effective_start_date date ;
10023: l_effective_end_date date ;
10024: l_prefix pqh_copy_entity_attribs.information1%type := null;
10025: l_suffix pqh_copy_entity_attribs.information1%type := null;
10026: l_new_value number(15);
10027: l_object_found_in_target boolean := false ;
10028: l_min_esd date;
10029: l_max_eed date;

Line 10518: l_prefix pqh_copy_entity_attribs.information1%type := null;

10514: l_elig_lvg_rsn_prte_id number ;
10515: l_object_version_number number ;
10516: l_effective_start_date date ;
10517: l_effective_end_date date ;
10518: l_prefix pqh_copy_entity_attribs.information1%type := null;
10519: l_suffix pqh_copy_entity_attribs.information1%type := null;
10520: l_new_value number(15);
10521: l_object_found_in_target boolean := false ;
10522: l_min_esd date;

Line 10519: l_suffix pqh_copy_entity_attribs.information1%type := null;

10515: l_object_version_number number ;
10516: l_effective_start_date date ;
10517: l_effective_end_date date ;
10518: l_prefix pqh_copy_entity_attribs.information1%type := null;
10519: l_suffix pqh_copy_entity_attribs.information1%type := null;
10520: l_new_value number(15);
10521: l_object_found_in_target boolean := false ;
10522: l_min_esd date;
10523: l_max_eed date;

Line 11014: l_prefix pqh_copy_entity_attribs.information1%type := null;

11010: l_elig_mrtl_sts_prte_id number ;
11011: l_object_version_number number ;
11012: l_effective_start_date date ;
11013: l_effective_end_date date ;
11014: l_prefix pqh_copy_entity_attribs.information1%type := null;
11015: l_suffix pqh_copy_entity_attribs.information1%type := null;
11016: l_new_value number(15);
11017: l_object_found_in_target boolean := false ;
11018: l_min_esd date;

Line 11015: l_suffix pqh_copy_entity_attribs.information1%type := null;

11011: l_object_version_number number ;
11012: l_effective_start_date date ;
11013: l_effective_end_date date ;
11014: l_prefix pqh_copy_entity_attribs.information1%type := null;
11015: l_suffix pqh_copy_entity_attribs.information1%type := null;
11016: l_new_value number(15);
11017: l_object_found_in_target boolean := false ;
11018: l_min_esd date;
11019: l_max_eed date;

Line 11508: l_prefix pqh_copy_entity_attribs.information1%type := null;

11504: l_elig_no_othr_cvg_prte_id number ;
11505: l_object_version_number number ;
11506: l_effective_start_date date ;
11507: l_effective_end_date date ;
11508: l_prefix pqh_copy_entity_attribs.information1%type := null;
11509: l_suffix pqh_copy_entity_attribs.information1%type := null;
11510: l_new_value number(15);
11511: l_object_found_in_target boolean := false ;
11512: l_min_esd date;

Line 11509: l_suffix pqh_copy_entity_attribs.information1%type := null;

11505: l_object_version_number number ;
11506: l_effective_start_date date ;
11507: l_effective_end_date date ;
11508: l_prefix pqh_copy_entity_attribs.information1%type := null;
11509: l_suffix pqh_copy_entity_attribs.information1%type := null;
11510: l_new_value number(15);
11511: l_object_found_in_target boolean := false ;
11512: l_min_esd date;
11513: l_max_eed date;

Line 11993: l_prefix pqh_copy_entity_attribs.information1%type := null;

11989: l_elig_optd_mdcr_prte_id number ;
11990: l_object_version_number number ;
11991: l_effective_start_date date ;
11992: l_effective_end_date date ;
11993: l_prefix pqh_copy_entity_attribs.information1%type := null;
11994: l_suffix pqh_copy_entity_attribs.information1%type := null;
11995: l_new_value number(15);
11996: l_object_found_in_target boolean := false ;
11997: l_min_esd date;

Line 11994: l_suffix pqh_copy_entity_attribs.information1%type := null;

11990: l_object_version_number number ;
11991: l_effective_start_date date ;
11992: l_effective_end_date date ;
11993: l_prefix pqh_copy_entity_attribs.information1%type := null;
11994: l_suffix pqh_copy_entity_attribs.information1%type := null;
11995: l_new_value number(15);
11996: l_object_found_in_target boolean := false ;
11997: l_min_esd date;
11998: l_max_eed date;

Line 12478: l_prefix pqh_copy_entity_attribs.information1%type := null;

12474: l_elig_org_unit_prte_id number ;
12475: l_object_version_number number ;
12476: l_effective_start_date date ;
12477: l_effective_end_date date ;
12478: l_prefix pqh_copy_entity_attribs.information1%type := null;
12479: l_suffix pqh_copy_entity_attribs.information1%type := null;
12480: l_new_value number(15);
12481: l_object_found_in_target boolean := false ;
12482: l_min_esd date;

Line 12479: l_suffix pqh_copy_entity_attribs.information1%type := null;

12475: l_object_version_number number ;
12476: l_effective_start_date date ;
12477: l_effective_end_date date ;
12478: l_prefix pqh_copy_entity_attribs.information1%type := null;
12479: l_suffix pqh_copy_entity_attribs.information1%type := null;
12480: l_new_value number(15);
12481: l_object_found_in_target boolean := false ;
12482: l_min_esd date;
12483: l_max_eed date;

Line 12998: l_prefix pqh_copy_entity_attribs.information1%type := null;

12994: l_elig_othr_ptip_prte_id number ;
12995: l_object_version_number number ;
12996: l_effective_start_date date ;
12997: l_effective_end_date date ;
12998: l_prefix pqh_copy_entity_attribs.information1%type := null;
12999: l_suffix pqh_copy_entity_attribs.information1%type := null;
13000: l_new_value number(15);
13001: l_object_found_in_target boolean := false ;
13002: l_min_esd date;

Line 12999: l_suffix pqh_copy_entity_attribs.information1%type := null;

12995: l_object_version_number number ;
12996: l_effective_start_date date ;
12997: l_effective_end_date date ;
12998: l_prefix pqh_copy_entity_attribs.information1%type := null;
12999: l_suffix pqh_copy_entity_attribs.information1%type := null;
13000: l_new_value number(15);
13001: l_object_found_in_target boolean := false ;
13002: l_min_esd date;
13003: l_max_eed date;

Line 13497: l_prefix pqh_copy_entity_attribs.information1%type := null;

13493: l_elig_pct_fl_tm_prte_id number ;
13494: l_object_version_number number ;
13495: l_effective_start_date date ;
13496: l_effective_end_date date ;
13497: l_prefix pqh_copy_entity_attribs.information1%type := null;
13498: l_suffix pqh_copy_entity_attribs.information1%type := null;
13499: l_new_value number(15);
13500: l_object_found_in_target boolean := false ;
13501: l_min_esd date;

Line 13498: l_suffix pqh_copy_entity_attribs.information1%type := null;

13494: l_object_version_number number ;
13495: l_effective_start_date date ;
13496: l_effective_end_date date ;
13497: l_prefix pqh_copy_entity_attribs.information1%type := null;
13498: l_suffix pqh_copy_entity_attribs.information1%type := null;
13499: l_new_value number(15);
13500: l_object_found_in_target boolean := false ;
13501: l_min_esd date;
13502: l_max_eed date;

Line 13994: l_prefix pqh_copy_entity_attribs.information1%type := null;

13990: l_elig_per_typ_prte_id number ;
13991: l_object_version_number number ;
13992: l_effective_start_date date ;
13993: l_effective_end_date date ;
13994: l_prefix pqh_copy_entity_attribs.information1%type := null;
13995: l_suffix pqh_copy_entity_attribs.information1%type := null;
13996: l_new_value number(15);
13997: l_object_found_in_target boolean := false ;
13998: l_min_esd date;

Line 13995: l_suffix pqh_copy_entity_attribs.information1%type := null;

13991: l_object_version_number number ;
13992: l_effective_start_date date ;
13993: l_effective_end_date date ;
13994: l_prefix pqh_copy_entity_attribs.information1%type := null;
13995: l_suffix pqh_copy_entity_attribs.information1%type := null;
13996: l_new_value number(15);
13997: l_object_found_in_target boolean := false ;
13998: l_min_esd date;
13999: l_max_eed date;

Line 14520: l_prefix pqh_copy_entity_attribs.information1%type := null;

14516: l_elig_ppl_grp_prte_id number ;
14517: l_object_version_number number ;
14518: l_effective_start_date date ;
14519: l_effective_end_date date ;
14520: l_prefix pqh_copy_entity_attribs.information1%type := null;
14521: l_suffix pqh_copy_entity_attribs.information1%type := null;
14522: l_new_value number(15);
14523: l_object_found_in_target boolean := false ;
14524: l_min_esd date;

Line 14521: l_suffix pqh_copy_entity_attribs.information1%type := null;

14517: l_object_version_number number ;
14518: l_effective_start_date date ;
14519: l_effective_end_date date ;
14520: l_prefix pqh_copy_entity_attribs.information1%type := null;
14521: l_suffix pqh_copy_entity_attribs.information1%type := null;
14522: l_new_value number(15);
14523: l_object_found_in_target boolean := false ;
14524: l_min_esd date;
14525: l_max_eed date;

Line 15023: l_prefix pqh_copy_entity_attribs.information1%type := null;

15019: l_elig_py_bss_prte_id number ;
15020: l_object_version_number number ;
15021: l_effective_start_date date ;
15022: l_effective_end_date date ;
15023: l_prefix pqh_copy_entity_attribs.information1%type := null;
15024: l_suffix pqh_copy_entity_attribs.information1%type := null;
15025: l_new_value number(15);
15026: l_object_found_in_target boolean := false ;
15027: l_min_esd date;

Line 15024: l_suffix pqh_copy_entity_attribs.information1%type := null;

15020: l_object_version_number number ;
15021: l_effective_start_date date ;
15022: l_effective_end_date date ;
15023: l_prefix pqh_copy_entity_attribs.information1%type := null;
15024: l_suffix pqh_copy_entity_attribs.information1%type := null;
15025: l_new_value number(15);
15026: l_object_found_in_target boolean := false ;
15027: l_min_esd date;
15028: l_max_eed date;

Line 15544: l_prefix pqh_copy_entity_attribs.information1%type := null;

15540: l_elig_prbtn_perd_prte_id number ;
15541: l_object_version_number number ;
15542: l_effective_start_date date ;
15543: l_effective_end_date date ;
15544: l_prefix pqh_copy_entity_attribs.information1%type := null;
15545: l_suffix pqh_copy_entity_attribs.information1%type := null;
15546: l_new_value number(15);
15547: l_object_found_in_target boolean := false ;
15548: l_min_esd date;

Line 15545: l_suffix pqh_copy_entity_attribs.information1%type := null;

15541: l_object_version_number number ;
15542: l_effective_start_date date ;
15543: l_effective_end_date date ;
15544: l_prefix pqh_copy_entity_attribs.information1%type := null;
15545: l_suffix pqh_copy_entity_attribs.information1%type := null;
15546: l_new_value number(15);
15547: l_object_found_in_target boolean := false ;
15548: l_min_esd date;
15549: l_max_eed date;

Line 16045: l_prefix pqh_copy_entity_attribs.information1%type := null;

16041: l_elig_prtt_anthr_pl_prte_id number ;
16042: l_object_version_number number ;
16043: l_effective_start_date date ;
16044: l_effective_end_date date ;
16045: l_prefix pqh_copy_entity_attribs.information1%type := null;
16046: l_suffix pqh_copy_entity_attribs.information1%type := null;
16047: l_new_value number(15);
16048: l_object_found_in_target boolean := false ;
16049: l_min_esd date;

Line 16046: l_suffix pqh_copy_entity_attribs.information1%type := null;

16042: l_object_version_number number ;
16043: l_effective_start_date date ;
16044: l_effective_end_date date ;
16045: l_prefix pqh_copy_entity_attribs.information1%type := null;
16046: l_suffix pqh_copy_entity_attribs.information1%type := null;
16047: l_new_value number(15);
16048: l_object_found_in_target boolean := false ;
16049: l_min_esd date;
16050: l_max_eed date;

Line 16535: l_prefix pqh_copy_entity_attribs.information1%type := null;

16531: l_elig_pstn_prte_id number ;
16532: l_object_version_number number ;
16533: l_effective_start_date date ;
16534: l_effective_end_date date ;
16535: l_prefix pqh_copy_entity_attribs.information1%type := null;
16536: l_suffix pqh_copy_entity_attribs.information1%type := null;
16537: l_new_value number(15);
16538: l_object_found_in_target boolean := false ;
16539: l_min_esd date;

Line 16536: l_suffix pqh_copy_entity_attribs.information1%type := null;

16532: l_object_version_number number ;
16533: l_effective_start_date date ;
16534: l_effective_end_date date ;
16535: l_prefix pqh_copy_entity_attribs.information1%type := null;
16536: l_suffix pqh_copy_entity_attribs.information1%type := null;
16537: l_new_value number(15);
16538: l_object_found_in_target boolean := false ;
16539: l_min_esd date;
16540: l_max_eed date;

Line 17051: l_prefix pqh_copy_entity_attribs.information1%type := null;

17047: l_elig_pyrl_prte_id number ;
17048: l_object_version_number number ;
17049: l_effective_start_date date ;
17050: l_effective_end_date date ;
17051: l_prefix pqh_copy_entity_attribs.information1%type := null;
17052: l_suffix pqh_copy_entity_attribs.information1%type := null;
17053: l_new_value number(15);
17054: l_object_found_in_target boolean := false ;
17055: l_min_esd date;

Line 17052: l_suffix pqh_copy_entity_attribs.information1%type := null;

17048: l_object_version_number number ;
17049: l_effective_start_date date ;
17050: l_effective_end_date date ;
17051: l_prefix pqh_copy_entity_attribs.information1%type := null;
17052: l_suffix pqh_copy_entity_attribs.information1%type := null;
17053: l_new_value number(15);
17054: l_object_found_in_target boolean := false ;
17055: l_min_esd date;
17056: l_max_eed date;

Line 17564: l_prefix pqh_copy_entity_attribs.information1%type := null;

17560: l_elig_pstl_cd_r_rng_prte_id number ;
17561: l_object_version_number number ;
17562: l_effective_start_date date ;
17563: l_effective_end_date date ;
17564: l_prefix pqh_copy_entity_attribs.information1%type := null;
17565: l_suffix pqh_copy_entity_attribs.information1%type := null;
17566: l_new_value number(15);
17567: l_object_found_in_target boolean := false ;
17568: l_min_esd date;

Line 17565: l_suffix pqh_copy_entity_attribs.information1%type := null;

17561: l_object_version_number number ;
17562: l_effective_start_date date ;
17563: l_effective_end_date date ;
17564: l_prefix pqh_copy_entity_attribs.information1%type := null;
17565: l_suffix pqh_copy_entity_attribs.information1%type := null;
17566: l_new_value number(15);
17567: l_object_found_in_target boolean := false ;
17568: l_min_esd date;
17569: l_max_eed date;

Line 18048: l_prefix pqh_copy_entity_attribs.information1%type := null;

18044: l_elig_qual_titl_prte_id number ;
18045: l_object_version_number number ;
18046: l_effective_start_date date ;
18047: l_effective_end_date date ;
18048: l_prefix pqh_copy_entity_attribs.information1%type := null;
18049: l_suffix pqh_copy_entity_attribs.information1%type := null;
18050: l_new_value number(15);
18051: l_object_found_in_target boolean := false ;
18052: l_min_esd date;

Line 18049: l_suffix pqh_copy_entity_attribs.information1%type := null;

18045: l_object_version_number number ;
18046: l_effective_start_date date ;
18047: l_effective_end_date date ;
18048: l_prefix pqh_copy_entity_attribs.information1%type := null;
18049: l_suffix pqh_copy_entity_attribs.information1%type := null;
18050: l_new_value number(15);
18051: l_object_found_in_target boolean := false ;
18052: l_min_esd date;
18053: l_max_eed date;

Line 18567: l_prefix pqh_copy_entity_attribs.information1%type := null;

18563: l_elig_svc_area_prte_id number ;
18564: l_object_version_number number ;
18565: l_effective_start_date date ;
18566: l_effective_end_date date ;
18567: l_prefix pqh_copy_entity_attribs.information1%type := null;
18568: l_suffix pqh_copy_entity_attribs.information1%type := null;
18569: l_new_value number(15);
18570: l_object_found_in_target boolean := false ;
18571: l_min_esd date;

Line 18568: l_suffix pqh_copy_entity_attribs.information1%type := null;

18564: l_object_version_number number ;
18565: l_effective_start_date date ;
18566: l_effective_end_date date ;
18567: l_prefix pqh_copy_entity_attribs.information1%type := null;
18568: l_suffix pqh_copy_entity_attribs.information1%type := null;
18569: l_new_value number(15);
18570: l_object_found_in_target boolean := false ;
18571: l_min_esd date;
18572: l_max_eed date;

Line 19102: l_prefix pqh_copy_entity_attribs.information1%type := null;

19098: l_elig_schedd_hrs_prte_id number ;
19099: l_object_version_number number ;
19100: l_effective_start_date date ;
19101: l_effective_end_date date ;
19102: l_prefix pqh_copy_entity_attribs.information1%type := null;
19103: l_suffix pqh_copy_entity_attribs.information1%type := null;
19104: l_new_value number(15);
19105: l_object_found_in_target boolean := false ;
19106: l_min_esd date;

Line 19103: l_suffix pqh_copy_entity_attribs.information1%type := null;

19099: l_object_version_number number ;
19100: l_effective_start_date date ;
19101: l_effective_end_date date ;
19102: l_prefix pqh_copy_entity_attribs.information1%type := null;
19103: l_suffix pqh_copy_entity_attribs.information1%type := null;
19104: l_new_value number(15);
19105: l_object_found_in_target boolean := false ;
19106: l_min_esd date;
19107: l_max_eed date;

Line 19627: l_prefix pqh_copy_entity_attribs.information1%type := null;

19623: l_elig_sp_clng_prg_prte_id number ;
19624: l_object_version_number number ;
19625: l_effective_start_date date ;
19626: l_effective_end_date date ;
19627: l_prefix pqh_copy_entity_attribs.information1%type := null;
19628: l_suffix pqh_copy_entity_attribs.information1%type := null;
19629: l_new_value number(15);
19630: l_object_found_in_target boolean := false ;
19631: l_min_esd date;

Line 19628: l_suffix pqh_copy_entity_attribs.information1%type := null;

19624: l_object_version_number number ;
19625: l_effective_start_date date ;
19626: l_effective_end_date date ;
19627: l_prefix pqh_copy_entity_attribs.information1%type := null;
19628: l_suffix pqh_copy_entity_attribs.information1%type := null;
19629: l_new_value number(15);
19630: l_object_found_in_target boolean := false ;
19631: l_min_esd date;
19632: l_max_eed date;

Line 20149: l_prefix pqh_copy_entity_attribs.information1%type := null;

20145: l_elig_suppl_role_prte_id number ;
20146: l_object_version_number number ;
20147: l_effective_start_date date ;
20148: l_effective_end_date date ;
20149: l_prefix pqh_copy_entity_attribs.information1%type := null;
20150: l_suffix pqh_copy_entity_attribs.information1%type := null;
20151: l_new_value number(15);
20152: l_object_found_in_target boolean := false ;
20153: l_min_esd date;

Line 20150: l_suffix pqh_copy_entity_attribs.information1%type := null;

20146: l_object_version_number number ;
20147: l_effective_start_date date ;
20148: l_effective_end_date date ;
20149: l_prefix pqh_copy_entity_attribs.information1%type := null;
20150: l_suffix pqh_copy_entity_attribs.information1%type := null;
20151: l_new_value number(15);
20152: l_object_found_in_target boolean := false ;
20153: l_min_esd date;
20154: l_max_eed date;

Line 20670: l_prefix pqh_copy_entity_attribs.information1%type := null;

20666: l_elig_wk_loc_prte_id number ;
20667: l_object_version_number number ;
20668: l_effective_start_date date ;
20669: l_effective_end_date date ;
20670: l_prefix pqh_copy_entity_attribs.information1%type := null;
20671: l_suffix pqh_copy_entity_attribs.information1%type := null;
20672: l_new_value number(15);
20673: l_object_found_in_target boolean := false ;
20674: l_min_esd date;

Line 20671: l_suffix pqh_copy_entity_attribs.information1%type := null;

20667: l_object_version_number number ;
20668: l_effective_start_date date ;
20669: l_effective_end_date date ;
20670: l_prefix pqh_copy_entity_attribs.information1%type := null;
20671: l_suffix pqh_copy_entity_attribs.information1%type := null;
20672: l_new_value number(15);
20673: l_object_found_in_target boolean := false ;
20674: l_min_esd date;
20675: l_max_eed date;

Line 21191: l_prefix pqh_copy_entity_attribs.information1%type := null;

21187: l_elig_dpnt_othr_ptip_id number ;
21188: l_object_version_number number ;
21189: l_effective_start_date date ;
21190: l_effective_end_date date ;
21191: l_prefix pqh_copy_entity_attribs.information1%type := null;
21192: l_suffix pqh_copy_entity_attribs.information1%type := null;
21193: l_new_value number(15);
21194: l_object_found_in_target boolean := false ;
21195: l_min_esd date;

Line 21192: l_suffix pqh_copy_entity_attribs.information1%type := null;

21188: l_object_version_number number ;
21189: l_effective_start_date date ;
21190: l_effective_end_date date ;
21191: l_prefix pqh_copy_entity_attribs.information1%type := null;
21192: l_suffix pqh_copy_entity_attribs.information1%type := null;
21193: l_new_value number(15);
21194: l_object_found_in_target boolean := false ;
21195: l_min_esd date;
21196: l_max_eed date;

Line 21699: l_prefix pqh_copy_entity_attribs.information1%type := null;

21695: l_elig_dsblty_ctg_prte_id number ;
21696: l_object_version_number number ;
21697: l_effective_start_date date ;
21698: l_effective_end_date date ;
21699: l_prefix pqh_copy_entity_attribs.information1%type := null;
21700: l_suffix pqh_copy_entity_attribs.information1%type := null;
21701: l_new_value number(15);
21702: l_object_found_in_target boolean := false ;
21703: l_min_esd date;

Line 21700: l_suffix pqh_copy_entity_attribs.information1%type := null;

21696: l_object_version_number number ;
21697: l_effective_start_date date ;
21698: l_effective_end_date date ;
21699: l_prefix pqh_copy_entity_attribs.information1%type := null;
21700: l_suffix pqh_copy_entity_attribs.information1%type := null;
21701: l_new_value number(15);
21702: l_object_found_in_target boolean := false ;
21703: l_min_esd date;
21704: l_max_eed date;

Line 22205: l_prefix pqh_copy_entity_attribs.information1%type := null;

22201: l_elig_dsblty_dgr_prte_id number ;
22202: l_object_version_number number ;
22203: l_effective_start_date date ;
22204: l_effective_end_date date ;
22205: l_prefix pqh_copy_entity_attribs.information1%type := null;
22206: l_suffix pqh_copy_entity_attribs.information1%type := null;
22207: l_new_value number(15);
22208: l_object_found_in_target boolean := false ;
22209: l_min_esd date;

Line 22206: l_suffix pqh_copy_entity_attribs.information1%type := null;

22202: l_object_version_number number ;
22203: l_effective_start_date date ;
22204: l_effective_end_date date ;
22205: l_prefix pqh_copy_entity_attribs.information1%type := null;
22206: l_suffix pqh_copy_entity_attribs.information1%type := null;
22207: l_new_value number(15);
22208: l_object_found_in_target boolean := false ;
22209: l_min_esd date;
22210: l_max_eed date;

Line 22714: l_prefix pqh_copy_entity_attribs.information1%type := null;

22710: l_elig_dsblty_rsn_prte_id number ;
22711: l_object_version_number number ;
22712: l_effective_start_date date ;
22713: l_effective_end_date date ;
22714: l_prefix pqh_copy_entity_attribs.information1%type := null;
22715: l_suffix pqh_copy_entity_attribs.information1%type := null;
22716: l_new_value number(15);
22717: l_object_found_in_target boolean := false ;
22718: l_min_esd date;

Line 22715: l_suffix pqh_copy_entity_attribs.information1%type := null;

22711: l_object_version_number number ;
22712: l_effective_start_date date ;
22713: l_effective_end_date date ;
22714: l_prefix pqh_copy_entity_attribs.information1%type := null;
22715: l_suffix pqh_copy_entity_attribs.information1%type := null;
22716: l_new_value number(15);
22717: l_object_found_in_target boolean := false ;
22718: l_min_esd date;
22719: l_max_eed date;

Line 23233: l_prefix pqh_copy_entity_attribs.information1%type := null;

23229: l_elig_ee_stat_prte_id number ;
23230: l_object_version_number number ;
23231: l_effective_start_date date ;
23232: l_effective_end_date date ;
23233: l_prefix pqh_copy_entity_attribs.information1%type := null;
23234: l_suffix pqh_copy_entity_attribs.information1%type := null;
23235: l_new_value number(15);
23236: l_object_found_in_target boolean := false ;
23237: l_min_esd date;

Line 23234: l_suffix pqh_copy_entity_attribs.information1%type := null;

23230: l_object_version_number number ;
23231: l_effective_start_date date ;
23232: l_effective_end_date date ;
23233: l_prefix pqh_copy_entity_attribs.information1%type := null;
23234: l_suffix pqh_copy_entity_attribs.information1%type := null;
23235: l_new_value number(15);
23236: l_object_found_in_target boolean := false ;
23237: l_min_esd date;
23238: l_max_eed date;

Line 23747: l_prefix pqh_copy_entity_attribs.information1%type := null;

23743: l_elig_enrld_anthr_oipl_id number ;
23744: l_object_version_number number ;
23745: l_effective_start_date date ;
23746: l_effective_end_date date ;
23747: l_prefix pqh_copy_entity_attribs.information1%type := null;
23748: l_suffix pqh_copy_entity_attribs.information1%type := null;
23749: l_new_value number(15);
23750: l_object_found_in_target boolean := false ;
23751: l_min_esd date;

Line 23748: l_suffix pqh_copy_entity_attribs.information1%type := null;

23744: l_object_version_number number ;
23745: l_effective_start_date date ;
23746: l_effective_end_date date ;
23747: l_prefix pqh_copy_entity_attribs.information1%type := null;
23748: l_suffix pqh_copy_entity_attribs.information1%type := null;
23749: l_new_value number(15);
23750: l_object_found_in_target boolean := false ;
23751: l_min_esd date;
23752: l_max_eed date;

Line 24241: l_prefix pqh_copy_entity_attribs.information1%type := null;

24237: l_elig_enrld_anthr_pgm_id number ;
24238: l_object_version_number number ;
24239: l_effective_start_date date ;
24240: l_effective_end_date date ;
24241: l_prefix pqh_copy_entity_attribs.information1%type := null;
24242: l_suffix pqh_copy_entity_attribs.information1%type := null;
24243: l_new_value number(15);
24244: l_object_found_in_target boolean := false ;
24245: l_min_esd date;

Line 24242: l_suffix pqh_copy_entity_attribs.information1%type := null;

24238: l_object_version_number number ;
24239: l_effective_start_date date ;
24240: l_effective_end_date date ;
24241: l_prefix pqh_copy_entity_attribs.information1%type := null;
24242: l_suffix pqh_copy_entity_attribs.information1%type := null;
24243: l_new_value number(15);
24244: l_object_found_in_target boolean := false ;
24245: l_min_esd date;
24246: l_max_eed date;

Line 24735: l_prefix pqh_copy_entity_attribs.information1%type := null;

24731: l_elig_enrld_anthr_plip_id number ;
24732: l_object_version_number number ;
24733: l_effective_start_date date ;
24734: l_effective_end_date date ;
24735: l_prefix pqh_copy_entity_attribs.information1%type := null;
24736: l_suffix pqh_copy_entity_attribs.information1%type := null;
24737: l_new_value number(15);
24738: l_object_found_in_target boolean := false ;
24739: l_min_esd date;

Line 24736: l_suffix pqh_copy_entity_attribs.information1%type := null;

24732: l_object_version_number number ;
24733: l_effective_start_date date ;
24734: l_effective_end_date date ;
24735: l_prefix pqh_copy_entity_attribs.information1%type := null;
24736: l_suffix pqh_copy_entity_attribs.information1%type := null;
24737: l_new_value number(15);
24738: l_object_found_in_target boolean := false ;
24739: l_min_esd date;
24740: l_max_eed date;

Line 25228: l_prefix pqh_copy_entity_attribs.information1%type := null;

25224: l_elig_enrld_anthr_pl_id number ;
25225: l_object_version_number number ;
25226: l_effective_start_date date ;
25227: l_effective_end_date date ;
25228: l_prefix pqh_copy_entity_attribs.information1%type := null;
25229: l_suffix pqh_copy_entity_attribs.information1%type := null;
25230: l_new_value number(15);
25231: l_object_found_in_target boolean := false ;
25232: l_min_esd date;

Line 25229: l_suffix pqh_copy_entity_attribs.information1%type := null;

25225: l_object_version_number number ;
25226: l_effective_start_date date ;
25227: l_effective_end_date date ;
25228: l_prefix pqh_copy_entity_attribs.information1%type := null;
25229: l_suffix pqh_copy_entity_attribs.information1%type := null;
25230: l_new_value number(15);
25231: l_object_found_in_target boolean := false ;
25232: l_min_esd date;
25233: l_max_eed date;

Line 25719: l_prefix pqh_copy_entity_attribs.information1%type := null;

25715: l_elig_enrld_anthr_ptip_id number ;
25716: l_object_version_number number ;
25717: l_effective_start_date date ;
25718: l_effective_end_date date ;
25719: l_prefix pqh_copy_entity_attribs.information1%type := null;
25720: l_suffix pqh_copy_entity_attribs.information1%type := null;
25721: l_new_value number(15);
25722: l_object_found_in_target boolean := false ;
25723: l_min_esd date;

Line 25720: l_suffix pqh_copy_entity_attribs.information1%type := null;

25716: l_object_version_number number ;
25717: l_effective_start_date date ;
25718: l_effective_end_date date ;
25719: l_prefix pqh_copy_entity_attribs.information1%type := null;
25720: l_suffix pqh_copy_entity_attribs.information1%type := null;
25721: l_new_value number(15);
25722: l_object_found_in_target boolean := false ;
25723: l_min_esd date;
25724: l_max_eed date;

Line 26224: l_prefix pqh_copy_entity_attribs.information1%type := null;

26220: l_elig_fl_tm_pt_tm_prte_id number ;
26221: l_object_version_number number ;
26222: l_effective_start_date date ;
26223: l_effective_end_date date ;
26224: l_prefix pqh_copy_entity_attribs.information1%type := null;
26225: l_suffix pqh_copy_entity_attribs.information1%type := null;
26226: l_new_value number(15);
26227: l_object_found_in_target boolean := false ;
26228: l_min_esd date;

Line 26225: l_suffix pqh_copy_entity_attribs.information1%type := null;

26221: l_object_version_number number ;
26222: l_effective_start_date date ;
26223: l_effective_end_date date ;
26224: l_prefix pqh_copy_entity_attribs.information1%type := null;
26225: l_suffix pqh_copy_entity_attribs.information1%type := null;
26226: l_new_value number(15);
26227: l_object_found_in_target boolean := false ;
26228: l_min_esd date;
26229: l_max_eed date;

Line 26730: l_prefix pqh_copy_entity_attribs.information1%type := null;

26726: l_elig_grd_prte_id number ;
26727: l_object_version_number number ;
26728: l_effective_start_date date ;
26729: l_effective_end_date date ;
26730: l_prefix pqh_copy_entity_attribs.information1%type := null;
26731: l_suffix pqh_copy_entity_attribs.information1%type := null;
26732: l_new_value number(15);
26733: l_object_found_in_target boolean := false ;
26734: l_min_esd date;

Line 26731: l_suffix pqh_copy_entity_attribs.information1%type := null;

26727: l_object_version_number number ;
26728: l_effective_start_date date ;
26729: l_effective_end_date date ;
26730: l_prefix pqh_copy_entity_attribs.information1%type := null;
26731: l_suffix pqh_copy_entity_attribs.information1%type := null;
26732: l_new_value number(15);
26733: l_object_found_in_target boolean := false ;
26734: l_min_esd date;
26735: l_max_eed date;

Line 27256: l_prefix pqh_copy_entity_attribs.information1%type := null;

27252: l_elig_hrly_slrd_prte_id number ;
27253: l_object_version_number number ;
27254: l_effective_start_date date ;
27255: l_effective_end_date date ;
27256: l_prefix pqh_copy_entity_attribs.information1%type := null;
27257: l_suffix pqh_copy_entity_attribs.information1%type := null;
27258: l_new_value number(15);
27259: l_object_found_in_target boolean := false ;
27260: l_min_esd date;

Line 27257: l_suffix pqh_copy_entity_attribs.information1%type := null;

27253: l_object_version_number number ;
27254: l_effective_start_date date ;
27255: l_effective_end_date date ;
27256: l_prefix pqh_copy_entity_attribs.information1%type := null;
27257: l_suffix pqh_copy_entity_attribs.information1%type := null;
27258: l_new_value number(15);
27259: l_object_found_in_target boolean := false ;
27260: l_min_esd date;
27261: l_max_eed date;

Line 27759: l_prefix pqh_copy_entity_attribs.information1%type := null;

27755: l_elig_perf_rtng_prte_id number ;
27756: l_object_version_number number ;
27757: l_effective_start_date date ;
27758: l_effective_end_date date ;
27759: l_prefix pqh_copy_entity_attribs.information1%type := null;
27760: l_suffix pqh_copy_entity_attribs.information1%type := null;
27761: l_new_value number(15);
27762: l_object_found_in_target boolean := false ;
27763: l_min_esd date;

Line 27760: l_suffix pqh_copy_entity_attribs.information1%type := null;

27756: l_object_version_number number ;
27757: l_effective_start_date date ;
27758: l_effective_end_date date ;
27759: l_prefix pqh_copy_entity_attribs.information1%type := null;
27760: l_suffix pqh_copy_entity_attribs.information1%type := null;
27761: l_new_value number(15);
27762: l_object_found_in_target boolean := false ;
27763: l_min_esd date;
27764: l_max_eed date;

Line 28260: l_prefix pqh_copy_entity_attribs.information1%type := null;

28256: l_elig_qua_in_gr_prte_id number ;
28257: l_object_version_number number ;
28258: l_effective_start_date date ;
28259: l_effective_end_date date ;
28260: l_prefix pqh_copy_entity_attribs.information1%type := null;
28261: l_suffix pqh_copy_entity_attribs.information1%type := null;
28262: l_new_value number(15);
28263: l_object_found_in_target boolean := false ;
28264: l_min_esd date;

Line 28261: l_suffix pqh_copy_entity_attribs.information1%type := null;

28257: l_object_version_number number ;
28258: l_effective_start_date date ;
28259: l_effective_end_date date ;
28260: l_prefix pqh_copy_entity_attribs.information1%type := null;
28261: l_suffix pqh_copy_entity_attribs.information1%type := null;
28262: l_new_value number(15);
28263: l_object_found_in_target boolean := false ;
28264: l_min_esd date;
28265: l_max_eed date;

Line 28756: l_prefix pqh_copy_entity_attribs.information1%type := null;

28752: l_elig_gndr_prte_id number ;
28753: l_object_version_number number ;
28754: l_effective_start_date date ;
28755: l_effective_end_date date ;
28756: l_prefix pqh_copy_entity_attribs.information1%type := null;
28757: l_suffix pqh_copy_entity_attribs.information1%type := null;
28758: l_new_value number(15);
28759: l_object_found_in_target boolean := false ;
28760: l_min_esd date;

Line 28757: l_suffix pqh_copy_entity_attribs.information1%type := null;

28753: l_object_version_number number ;
28754: l_effective_start_date date ;
28755: l_effective_end_date date ;
28756: l_prefix pqh_copy_entity_attribs.information1%type := null;
28757: l_suffix pqh_copy_entity_attribs.information1%type := null;
28758: l_new_value number(15);
28759: l_object_found_in_target boolean := false ;
28760: l_min_esd date;
28761: l_max_eed date;

Line 29251: l_prefix pqh_copy_entity_attribs.information1%type := null;

29247: l_elig_tbco_use_prte_id number ;
29248: l_object_version_number number ;
29249: l_effective_start_date date ;
29250: l_effective_end_date date ;
29251: l_prefix pqh_copy_entity_attribs.information1%type := null;
29252: l_suffix pqh_copy_entity_attribs.information1%type := null;
29253: l_new_value number(15);
29254: l_object_found_in_target boolean := false ;
29255: l_min_esd date;

Line 29252: l_suffix pqh_copy_entity_attribs.information1%type := null;

29248: l_object_version_number number ;
29249: l_effective_start_date date ;
29250: l_effective_end_date date ;
29251: l_prefix pqh_copy_entity_attribs.information1%type := null;
29252: l_suffix pqh_copy_entity_attribs.information1%type := null;
29253: l_new_value number(15);
29254: l_object_found_in_target boolean := false ;
29255: l_min_esd date;
29256: l_max_eed date;

Line 29742: l_prefix pqh_copy_entity_attribs.information1%type := null;

29738: l_elig_dsbld_prte_id number ;
29739: l_object_version_number number ;
29740: l_effective_start_date date ;
29741: l_effective_end_date date ;
29742: l_prefix pqh_copy_entity_attribs.information1%type := null;
29743: l_suffix pqh_copy_entity_attribs.information1%type := null;
29744: l_new_value number(15);
29745: l_object_found_in_target boolean := false ;
29746: l_min_esd date;

Line 29743: l_suffix pqh_copy_entity_attribs.information1%type := null;

29739: l_object_version_number number ;
29740: l_effective_start_date date ;
29741: l_effective_end_date date ;
29742: l_prefix pqh_copy_entity_attribs.information1%type := null;
29743: l_suffix pqh_copy_entity_attribs.information1%type := null;
29744: l_new_value number(15);
29745: l_object_found_in_target boolean := false ;
29746: l_min_esd date;
29747: l_max_eed date;

Line 30254: l_prefix pqh_copy_entity_attribs.information1%type := null;

30250: l_elig_ttl_prtt_prte_id number ;
30251: l_object_version_number number ;
30252: l_effective_start_date date ;
30253: l_effective_end_date date ;
30254: l_prefix pqh_copy_entity_attribs.information1%type := null;
30255: l_suffix pqh_copy_entity_attribs.information1%type := null;
30256: l_new_value number(15);
30257: l_object_found_in_target boolean := false ;
30258: l_min_esd date;

Line 30255: l_suffix pqh_copy_entity_attribs.information1%type := null;

30251: l_object_version_number number ;
30252: l_effective_start_date date ;
30253: l_effective_end_date date ;
30254: l_prefix pqh_copy_entity_attribs.information1%type := null;
30255: l_suffix pqh_copy_entity_attribs.information1%type := null;
30256: l_new_value number(15);
30257: l_object_found_in_target boolean := false ;
30258: l_min_esd date;
30259: l_max_eed date;

Line 30784: l_prefix pqh_copy_entity_attribs.information1%type := null;

30780: l_elig_ttl_cvg_vol_prte_id number ;
30781: l_object_version_number number ;
30782: l_effective_start_date date ;
30783: l_effective_end_date date ;
30784: l_prefix pqh_copy_entity_attribs.information1%type := null;
30785: l_suffix pqh_copy_entity_attribs.information1%type := null;
30786: l_new_value number(15);
30787: l_object_found_in_target boolean := false ;
30788: l_min_esd date;

Line 30785: l_suffix pqh_copy_entity_attribs.information1%type := null;

30781: l_object_version_number number ;
30782: l_effective_start_date date ;
30783: l_effective_end_date date ;
30784: l_prefix pqh_copy_entity_attribs.information1%type := null;
30785: l_suffix pqh_copy_entity_attribs.information1%type := null;
30786: l_new_value number(15);
30787: l_object_found_in_target boolean := false ;
30788: l_min_esd date;
30789: l_max_eed date;

Line 31297: l_prefix pqh_copy_entity_attribs.information1%type := null;

31293: l_elig_hlth_cvg_prte_id number ;
31294: l_object_version_number number ;
31295: l_effective_start_date date ;
31296: l_effective_end_date date ;
31297: l_prefix pqh_copy_entity_attribs.information1%type := null;
31298: l_suffix pqh_copy_entity_attribs.information1%type := null;
31299: l_new_value number(15);
31300: l_object_found_in_target boolean := false ;
31301: l_min_esd date;

Line 31298: l_suffix pqh_copy_entity_attribs.information1%type := null;

31294: l_object_version_number number ;
31295: l_effective_start_date date ;
31296: l_effective_end_date date ;
31297: l_prefix pqh_copy_entity_attribs.information1%type := null;
31298: l_suffix pqh_copy_entity_attribs.information1%type := null;
31299: l_new_value number(15);
31300: l_object_found_in_target boolean := false ;
31301: l_min_esd date;
31302: l_max_eed date;

Line 31791: l_prefix pqh_copy_entity_attribs.information1%type := null;

31787: l_elig_anthr_pl_prte_id number ;
31788: l_object_version_number number ;
31789: l_effective_start_date date ;
31790: l_effective_end_date date ;
31791: l_prefix pqh_copy_entity_attribs.information1%type := null;
31792: l_suffix pqh_copy_entity_attribs.information1%type := null;
31793: l_new_value number(15);
31794: l_object_found_in_target boolean := false ;
31795: l_min_esd date;

Line 31792: l_suffix pqh_copy_entity_attribs.information1%type := null;

31788: l_object_version_number number ;
31789: l_effective_start_date date ;
31790: l_effective_end_date date ;
31791: l_prefix pqh_copy_entity_attribs.information1%type := null;
31792: l_suffix pqh_copy_entity_attribs.information1%type := null;
31793: l_new_value number(15);
31794: l_object_found_in_target boolean := false ;
31795: l_min_esd date;
31796: l_max_eed date;

Line 32474: FROM pqh_copy_entity_attribs

32470: --
32471: CURSOR c_target_type
32472: IS
32473: SELECT information3
32474: FROM pqh_copy_entity_attribs
32475: WHERE copy_entity_Txn_id = p_copy_entity_txn_id;
32476: --
32477: CURSOR c_display_name (p_table_alias VARCHAR2)
32478: IS

Line 32508: l_prefix pqh_copy_entity_attribs.information1%TYPE

32504: l_eligy_crit_values_id NUMBER;
32505: l_object_version_number NUMBER;
32506: l_effective_start_date DATE;
32507: l_effective_end_date DATE;
32508: l_prefix pqh_copy_entity_attribs.information1%TYPE
32509: := NULL;
32510: l_suffix pqh_copy_entity_attribs.information1%TYPE
32511: := NULL;
32512: l_new_value NUMBER (15);

Line 32510: l_suffix pqh_copy_entity_attribs.information1%TYPE

32506: l_effective_start_date DATE;
32507: l_effective_end_date DATE;
32508: l_prefix pqh_copy_entity_attribs.information1%TYPE
32509: := NULL;
32510: l_suffix pqh_copy_entity_attribs.information1%TYPE
32511: := NULL;
32512: l_new_value NUMBER (15);
32513: l_object_found_in_target BOOLEAN := FALSE;
32514: l_min_esd DATE;