APPS.BEN_DISTRIBUTE_RATES dependencies on HR_ELEMENTS

Line 77: Call hr_elements.check_element_freq only

73: -cursor in get_periods_between changed after
74: going thro Bug#1309417 and 1237278 - also modified
75: parameter value for opening cursor parse_period
76: 17-May-01 maagrawa 115.26 - Performance changes.
77: Call hr_elements.check_element_freq only
78: if the rule exists.
79: 29-Aug-01 pbodla 115.27 - bug:1949361 jurisdiction code is
80: derived inside benutils.formula
81: 18-Sep-01 kmahendr 115.28 - bug-1996066-where clause in cursors c_parse_periods and

Line 627: hr_elements.check_element_freq(

623: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
624: p_start_date,
625: nvl(p_end_date,l_end_date))
626: LOOP
627: hr_elements.check_element_freq(
628: p_payroll_id =>p_payroll_id,
629: p_bg_id =>p_business_group_id,
630: p_pay_action_id =>TO_NUMBER(null),
631: p_date_earned =>l_parse_periods.end_date,

Line 656: hr_elements.check_element_freq(

652: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
653: p_start_date,
654: p_end_date)
655: LOOP
656: hr_elements.check_element_freq(
657: p_payroll_id =>p_payroll_id,
658: p_bg_id =>p_business_group_id,
659: p_pay_action_id =>TO_NUMBER(null),
660: p_date_earned =>l_parse_periods.end_date,

Line 684: hr_elements.check_element_freq(

680: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
681: p_start_date,
682: ADD_MONTHS(TRUNC(p_start_date,l_reset),1) -1)
683: LOOP
684: hr_elements.check_element_freq(
685: p_payroll_id =>p_payroll_id,
686: p_bg_id =>p_business_group_id,
687: p_pay_action_id =>TO_NUMBER(null),
688: p_date_earned =>l_parse_periods.end_date,

Line 716: hr_elements.check_element_freq(

712: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
713: TRUNC(NVL(p_end_date, l_end_date),l_reset), -- 3704632 : Added NVL() to p_end_date
714: NVL(p_end_date, l_end_date)) -- 3704632 : Added NVL() to p_end_date
715: LOOP
716: hr_elements.check_element_freq(
717: p_payroll_id =>p_payroll_id,
718: p_bg_id =>p_business_group_id,
719: p_pay_action_id =>TO_NUMBER(null),
720: p_date_earned =>l_parse_periods.end_date,

Line 882: hr_elements.check_element_freq(

878: for l_parse_periods in c_parse_periods1(p_payroll_id,
879: p_start_date,
880: nvl(p_end_date,l_end_date))
881: loop
882: hr_elements.check_element_freq(
883: p_payroll_id =>p_payroll_id,
884: p_bg_id =>p_business_group_id,
885: p_pay_action_id =>to_number(null),
886: p_date_earned =>l_parse_periods.end_date,

Line 1281: hr_elements.check_element_freq(

1277: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1278: p_start_date,
1279: nvl(p_end_date,l_end_date))
1280: LOOP
1281: hr_elements.check_element_freq(
1282: p_payroll_id =>p_payroll_id,
1283: p_bg_id =>p_business_group_id,
1284: p_pay_action_id =>TO_NUMBER(null),
1285: p_date_earned =>l_parse_periods.end_date,

Line 1309: hr_elements.check_element_freq(

1305: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1306: p_start_date,
1307: p_end_date)
1308: LOOP
1309: hr_elements.check_element_freq(
1310: p_payroll_id =>p_payroll_id,
1311: p_bg_id =>p_business_group_id,
1312: p_pay_action_id =>TO_NUMBER(null),
1313: p_date_earned =>l_parse_periods.end_date,

Line 1335: hr_elements.check_element_freq(

1331: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1332: p_start_date,
1333: ADD_MONTHS(TRUNC(p_start_date,l_reset),1) -1)
1334: LOOP
1335: hr_elements.check_element_freq(
1336: p_payroll_id =>p_payroll_id,
1337: p_bg_id =>p_business_group_id,
1338: p_pay_action_id =>TO_NUMBER(null),
1339: p_date_earned =>l_parse_periods.end_date,

Line 1365: hr_elements.check_element_freq(

1361: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1362: TRUNC(p_end_date,l_reset),
1363: p_end_date)
1364: LOOP
1365: hr_elements.check_element_freq(
1366: p_payroll_id =>p_payroll_id,
1367: p_bg_id =>p_business_group_id,
1368: p_pay_action_id =>TO_NUMBER(null),
1369: p_date_earned =>l_parse_periods.end_date,