DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PER_CM_USG_F

Line 707: procedure pop_ben_per_cm_usg_f

703: hr_utility.set_location('Leaving: '||l_proc,10);
704: --
705: end pop_ben_per_cm_prvdd_f;
706: --
707: procedure pop_ben_per_cm_usg_f
708: (p_per_cm_id in number,
709: p_cm_typ_usg_id in number,
710: p_business_group_id in number,
711: p_effective_date in date,

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

711: p_effective_date in date,
712: p_per_cm_usg_id out nocopy number,
713: p_usage_created out nocopy boolean) is
714: --
715: l_proc varchar2(80) := g_package||'pop_ben_per_cm_usg_f';
716: --
717: -- Output variables
718: --
719: l_object_version_number number;

Line 725: from ben_per_cm_usg_f pcu

721: l_effective_end_date date;
722: --
723: cursor c1 is
724: select pcu.per_cm_usg_id
725: from ben_per_cm_usg_f pcu
726: where pcu.per_cm_id = p_per_cm_id
727: and pcu.cm_typ_usg_id = p_cm_typ_usg_id
728: and pcu.business_group_id = p_business_group_id
729: and ben_generate_communications.g_comm_start_date between

Line 793: end pop_ben_per_cm_usg_f;

789: close c1;
790: --
791: hr_utility.set_location('Leaving: '||l_proc,10);
792: --
793: end pop_ben_per_cm_usg_f;
794: --
795: procedure populate_working_tables
796: (p_person_id in number,
797: p_cm_typ_id in number,

Line 1232: pop_ben_per_cm_usg_f

1228: p_effective_date => l_effective_date) then
1229: --
1230: -- create usage
1231: --
1232: pop_ben_per_cm_usg_f
1233: (p_per_cm_id => p_per_cm_id,
1234: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
1235: p_business_group_id => p_business_group_id,
1236: p_effective_date => p_effective_date,

Line 1418: pop_ben_per_cm_usg_f

1414: p_effective_date => l_effective_date) then
1415: --
1416: -- create usage
1417: --
1418: pop_ben_per_cm_usg_f
1419: (p_per_cm_id => p_per_cm_id,
1420: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
1421: p_business_group_id => p_business_group_id,
1422: p_effective_date => p_effective_date,

Line 1646: pop_ben_per_cm_usg_f

1642: then
1643: --
1644: -- create usage
1645: --
1646: pop_ben_per_cm_usg_f
1647: (p_per_cm_id => p_per_cm_id
1648: ,p_cm_typ_usg_id => l_ctu_cm_typ_usg_id_va(ctuva)
1649: ,p_business_group_id => p_business_group_id
1650: ,p_effective_date => p_effective_date

Line 1693: pop_ben_per_cm_usg_f

1689: p_effective_date => l_effective_date) then
1690: --
1691: -- create usage
1692: --
1693: pop_ben_per_cm_usg_f
1694: (p_per_cm_id => p_per_cm_id,
1695: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
1696: p_business_group_id => p_business_group_id,
1697: p_effective_date => p_effective_date,

Line 1840: pop_ben_per_cm_usg_f

1836: p_effective_date => l_effective_date) then
1837: --
1838: -- create usage
1839: --
1840: pop_ben_per_cm_usg_f
1841: (p_per_cm_id => p_per_cm_id,
1842: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
1843: p_business_group_id => p_business_group_id,
1844: p_effective_date => p_effective_date,

Line 2027: pop_ben_per_cm_usg_f

2023: p_effective_date => l_effective_date) then
2024: --
2025: -- create usage
2026: --
2027: pop_ben_per_cm_usg_f
2028: (p_per_cm_id => p_per_cm_id,
2029: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2030: p_business_group_id => p_business_group_id,
2031: p_effective_date => p_effective_date,

Line 2197: pop_ben_per_cm_usg_f

2193: p_effective_date => l_effective_date) then
2194: --
2195: -- create usage
2196: --
2197: pop_ben_per_cm_usg_f
2198: (p_per_cm_id => p_per_cm_id,
2199: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2200: p_business_group_id => p_business_group_id,
2201: p_effective_date => p_effective_date,

Line 2348: pop_ben_per_cm_usg_f

2344: p_effective_date => l_effective_date) then
2345: --
2346: -- create usage
2347: --
2348: pop_ben_per_cm_usg_f
2349: (p_per_cm_id => p_per_cm_id,
2350: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2351: p_business_group_id => p_business_group_id,
2352: p_effective_date => p_effective_date,

Line 2481: pop_ben_per_cm_usg_f

2477: p_effective_date => l_effective_date) then
2478: --
2479: -- create usage
2480: --
2481: pop_ben_per_cm_usg_f
2482: (p_per_cm_id => p_per_cm_id,
2483: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2484: p_business_group_id => p_business_group_id,
2485: p_effective_date => p_effective_date,

Line 2604: pop_ben_per_cm_usg_f

2600: p_effective_date => l_effective_date) then
2601: --
2602: -- create usage
2603: --
2604: pop_ben_per_cm_usg_f
2605: (p_per_cm_id => p_per_cm_id,
2606: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2607: p_business_group_id => p_business_group_id,
2608: 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 2833: pop_ben_per_cm_usg_f

2829: p_effective_date => l_effective_date) then
2830: --
2831: -- create usage
2832: --
2833: pop_ben_per_cm_usg_f
2834: (p_per_cm_id => p_per_cm_id,
2835: p_cm_typ_usg_id => l_mssmlg.cm_typ_usg_id,
2836: p_business_group_id => p_business_group_id,
2837: p_effective_date => p_effective_date,

Line 2981: pop_ben_per_cm_usg_f

2977: p_effective_date => l_effective_date) then
2978: --
2979: -- create usage
2980: --
2981: pop_ben_per_cm_usg_f
2982: (p_per_cm_id => p_per_cm_id,
2983: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
2984: p_business_group_id => p_business_group_id,
2985: p_effective_date => p_effective_date,

Line 3106: pop_ben_per_cm_usg_f

3102: p_effective_date => l_effective_date) then
3103: --
3104: -- create usage
3105: --
3106: pop_ben_per_cm_usg_f
3107: (p_per_cm_id => p_per_cm_id,
3108: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
3109: p_business_group_id => p_business_group_id,
3110: p_effective_date => p_effective_date,

Line 3277: pop_ben_per_cm_usg_f

3273: p_effective_date => l_effective_date) then
3274: --
3275: -- create usage
3276: --
3277: pop_ben_per_cm_usg_f
3278: (p_per_cm_id => p_per_cm_id,
3279: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
3280: p_business_group_id => p_business_group_id,
3281: p_effective_date => p_effective_date,

Line 3426: pop_ben_per_cm_usg_f

3422: p_effective_date => l_effective_date) then
3423: --
3424: -- create usage
3425: --
3426: pop_ben_per_cm_usg_f
3427: (p_per_cm_id => p_per_cm_id,
3428: p_cm_typ_usg_id => l_c1.cm_typ_usg_id,
3429: p_business_group_id => p_business_group_id,
3430: p_effective_date => p_effective_date,

Line 4414: -- 6b. Populate ben_per_cm_usg_f

4410: -- 4b. Populate ben_per_cm_prvdd_f
4411: -- 6. If whnvr_trgrd_flag = 'N' then join to cm_typ_usg_f
4412: -- 7. If rule exists or no rule and a usage exists
4413: -- 6a. Populate ben_per_cm_trgr_f
4414: -- 6b. Populate ben_per_cm_usg_f
4415: -- 6c. Populate ben_per_cm_f
4416: -- 6d. Populate ben_per_cm_prvdd_f
4417: -- 8. Go to 2.
4418: --