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_GENERATE_COMMUNICATIONS dependencies on BEN_PER_CM_USG_F

Line 843: procedure pop_ben_per_cm_usg_f

839: hr_utility.set_location('Leaving: '||l_proc,10);
840: --
841: end pop_ben_per_cm_prvdd_f;
842: --
843: procedure pop_ben_per_cm_usg_f
844: (p_per_cm_id in number,
845: p_cm_typ_usg_id in number,
846: p_business_group_id in number,
847: p_effective_date in date,

Line 851: l_proc varchar2(80) := g_package||'pop_ben_per_cm_usg_f';

847: p_effective_date in date,
848: p_per_cm_usg_id out nocopy number,
849: p_usage_created out nocopy boolean) is
850: --
851: l_proc varchar2(80) := g_package||'pop_ben_per_cm_usg_f';
852: --
853: -- Output variables
854: --
855: l_object_version_number number;

Line 861: from ben_per_cm_usg_f pcu

857: l_effective_end_date date;
858: --
859: cursor c1 is
860: select pcu.per_cm_usg_id
861: from ben_per_cm_usg_f pcu
862: where pcu.per_cm_id = p_per_cm_id
863: and pcu.cm_typ_usg_id = p_cm_typ_usg_id
864: and pcu.business_group_id = p_business_group_id
865: and ben_generate_communications.g_comm_start_date between

Line 929: end pop_ben_per_cm_usg_f;

925: close c1;
926: --
927: hr_utility.set_location('Leaving: '||l_proc,10);
928: --
929: end pop_ben_per_cm_usg_f;
930: --
931: procedure populate_working_tables
932: (p_person_id in number,
933: p_cm_typ_id in number,

Line 1471: pop_ben_per_cm_usg_f

1467: p_effective_date => l_effective_date) then
1468: --
1469: -- create usage
1470: --
1471: pop_ben_per_cm_usg_f
1472: (p_per_cm_id => p_per_cm_id,
1473: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
1474: p_business_group_id => p_business_group_id,
1475: p_effective_date => p_effective_date,

Line 1657: pop_ben_per_cm_usg_f

1653: p_effective_date => l_effective_date) then
1654: --
1655: -- create usage
1656: --
1657: pop_ben_per_cm_usg_f
1658: (p_per_cm_id => p_per_cm_id,
1659: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
1660: p_business_group_id => p_business_group_id,
1661: p_effective_date => p_effective_date,

Line 1885: pop_ben_per_cm_usg_f

1881: then
1882: --
1883: -- create usage
1884: --
1885: pop_ben_per_cm_usg_f
1886: (p_per_cm_id => p_per_cm_id
1887: ,p_cm_typ_usg_id => l_ctu_cm_typ_usg_id_va(ctuva)
1888: ,p_business_group_id => p_business_group_id
1889: ,p_effective_date => p_effective_date

Line 1932: pop_ben_per_cm_usg_f

1928: p_effective_date => l_effective_date) then
1929: --
1930: -- create usage
1931: --
1932: pop_ben_per_cm_usg_f
1933: (p_per_cm_id => p_per_cm_id,
1934: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
1935: p_business_group_id => p_business_group_id,
1936: p_effective_date => p_effective_date,

Line 2079: pop_ben_per_cm_usg_f

2075: p_effective_date => l_effective_date) then
2076: --
2077: -- create usage
2078: --
2079: pop_ben_per_cm_usg_f
2080: (p_per_cm_id => p_per_cm_id,
2081: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2082: p_business_group_id => p_business_group_id,
2083: p_effective_date => p_effective_date,

Line 2266: pop_ben_per_cm_usg_f

2262: p_effective_date => l_effective_date) then
2263: --
2264: -- create usage
2265: --
2266: pop_ben_per_cm_usg_f
2267: (p_per_cm_id => p_per_cm_id,
2268: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2269: p_business_group_id => p_business_group_id,
2270: p_effective_date => p_effective_date,

Line 2436: pop_ben_per_cm_usg_f

2432: p_effective_date => l_effective_date) then
2433: --
2434: -- create usage
2435: --
2436: pop_ben_per_cm_usg_f
2437: (p_per_cm_id => p_per_cm_id,
2438: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2439: p_business_group_id => p_business_group_id,
2440: p_effective_date => p_effective_date,

Line 2587: pop_ben_per_cm_usg_f

2583: p_effective_date => l_effective_date) then
2584: --
2585: -- create usage
2586: --
2587: pop_ben_per_cm_usg_f
2588: (p_per_cm_id => p_per_cm_id,
2589: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2590: p_business_group_id => p_business_group_id,
2591: p_effective_date => p_effective_date,

Line 2720: pop_ben_per_cm_usg_f

2716: p_effective_date => l_effective_date) then
2717: --
2718: -- create usage
2719: --
2720: pop_ben_per_cm_usg_f
2721: (p_per_cm_id => p_per_cm_id,
2722: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2723: p_business_group_id => p_business_group_id,
2724: p_effective_date => p_effective_date,

Line 2843: pop_ben_per_cm_usg_f

2839: p_effective_date => l_effective_date) then
2840: --
2841: -- create usage
2842: --
2843: pop_ben_per_cm_usg_f
2844: (p_per_cm_id => p_per_cm_id,
2845: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2846: p_business_group_id => p_business_group_id,
2847: p_effective_date => p_effective_date,

Line 2959: pop_ben_per_cm_usg_f

2955: p_effective_date => l_effective_date) then
2956: --
2957: -- create usage
2958: --
2959: pop_ben_per_cm_usg_f
2960: (p_per_cm_id => p_per_cm_id,
2961: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2962: p_business_group_id => p_business_group_id,
2963: p_effective_date => p_effective_date,

Line 3072: pop_ben_per_cm_usg_f

3068: p_effective_date => l_effective_date) then
3069: --
3070: -- create usage
3071: --
3072: pop_ben_per_cm_usg_f
3073: (p_per_cm_id => p_per_cm_id,
3074: p_cm_typ_usg_id => l_mssmlg.cm_typ_usg_id,
3075: p_business_group_id => p_business_group_id,
3076: p_effective_date => p_effective_date,

Line 3220: pop_ben_per_cm_usg_f

3216: p_effective_date => l_effective_date) then
3217: --
3218: -- create usage
3219: --
3220: pop_ben_per_cm_usg_f
3221: (p_per_cm_id => p_per_cm_id,
3222: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
3223: p_business_group_id => p_business_group_id,
3224: p_effective_date => p_effective_date,

Line 3345: pop_ben_per_cm_usg_f

3341: p_effective_date => l_effective_date) then
3342: --
3343: -- create usage
3344: --
3345: pop_ben_per_cm_usg_f
3346: (p_per_cm_id => p_per_cm_id,
3347: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
3348: p_business_group_id => p_business_group_id,
3349: p_effective_date => p_effective_date,

Line 3516: pop_ben_per_cm_usg_f

3512: p_effective_date => l_effective_date) then
3513: --
3514: -- create usage
3515: --
3516: pop_ben_per_cm_usg_f
3517: (p_per_cm_id => p_per_cm_id,
3518: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
3519: p_business_group_id => p_business_group_id,
3520: p_effective_date => p_effective_date,

Line 3665: pop_ben_per_cm_usg_f

3661: p_effective_date => l_effective_date) then
3662: --
3663: -- create usage
3664: --
3665: pop_ben_per_cm_usg_f
3666: (p_per_cm_id => p_per_cm_id,
3667: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
3668: p_business_group_id => p_business_group_id,
3669: p_effective_date => p_effective_date,

Line 4748: -- 6b. Populate ben_per_cm_usg_f

4744: -- 4b. Populate ben_per_cm_prvdd_f
4745: -- 6. If whnvr_trgrd_flag = 'N' then join to cm_typ_usg_f
4746: -- 7. If rule exists or no rule and a usage exists
4747: -- 6a. Populate ben_per_cm_trgr_f
4748: -- 6b. Populate ben_per_cm_usg_f
4749: -- 6c. Populate ben_per_cm_f
4750: -- 6d. Populate ben_per_cm_prvdd_f
4751: -- 8. Go to 2.
4752: --