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 661: hr_elements.check_element_freq(

657: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
658: p_start_date,
659: nvl(p_end_date,l_end_date))
660: LOOP
661: hr_elements.check_element_freq(
662: p_payroll_id =>p_payroll_id,
663: p_bg_id =>p_business_group_id,
664: p_pay_action_id =>TO_NUMBER(null),
665: p_date_earned =>l_parse_periods.end_date,

Line 690: hr_elements.check_element_freq(

686: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
687: p_start_date,
688: p_end_date)
689: LOOP
690: hr_elements.check_element_freq(
691: p_payroll_id =>p_payroll_id,
692: p_bg_id =>p_business_group_id,
693: p_pay_action_id =>TO_NUMBER(null),
694: p_date_earned =>l_parse_periods.end_date,

Line 718: hr_elements.check_element_freq(

714: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
715: p_start_date,
716: ADD_MONTHS(TRUNC(p_start_date,l_reset),1) -1)
717: LOOP
718: hr_elements.check_element_freq(
719: p_payroll_id =>p_payroll_id,
720: p_bg_id =>p_business_group_id,
721: p_pay_action_id =>TO_NUMBER(null),
722: p_date_earned =>l_parse_periods.end_date,

Line 750: hr_elements.check_element_freq(

746: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
747: TRUNC(NVL(p_end_date, l_end_date),l_reset), -- 3704632 : Added NVL() to p_end_date
748: NVL(p_end_date, l_end_date)) -- 3704632 : Added NVL() to p_end_date
749: LOOP
750: hr_elements.check_element_freq(
751: p_payroll_id =>p_payroll_id,
752: p_bg_id =>p_business_group_id,
753: p_pay_action_id =>TO_NUMBER(null),
754: p_date_earned =>l_parse_periods.end_date,

Line 916: hr_elements.check_element_freq(

912: for l_parse_periods in c_parse_periods1(p_payroll_id,
913: p_start_date,
914: nvl(p_end_date,l_end_date))
915: loop
916: hr_elements.check_element_freq(
917: p_payroll_id =>p_payroll_id,
918: p_bg_id =>p_business_group_id,
919: p_pay_action_id =>to_number(null),
920: p_date_earned =>l_parse_periods.end_date,

Line 1355: hr_elements.check_element_freq(

1351: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1352: p_start_date,
1353: nvl(p_end_date,l_end_date))
1354: LOOP
1355: hr_elements.check_element_freq(
1356: p_payroll_id =>p_payroll_id,
1357: p_bg_id =>p_business_group_id,
1358: p_pay_action_id =>TO_NUMBER(null),
1359: p_date_earned =>l_parse_periods.end_date,

Line 1383: hr_elements.check_element_freq(

1379: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1380: p_start_date,
1381: p_end_date)
1382: LOOP
1383: hr_elements.check_element_freq(
1384: p_payroll_id =>p_payroll_id,
1385: p_bg_id =>p_business_group_id,
1386: p_pay_action_id =>TO_NUMBER(null),
1387: p_date_earned =>l_parse_periods.end_date,

Line 1409: hr_elements.check_element_freq(

1405: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1406: p_start_date,
1407: ADD_MONTHS(TRUNC(p_start_date,l_reset),1) -1)
1408: LOOP
1409: hr_elements.check_element_freq(
1410: p_payroll_id =>p_payroll_id,
1411: p_bg_id =>p_business_group_id,
1412: p_pay_action_id =>TO_NUMBER(null),
1413: p_date_earned =>l_parse_periods.end_date,

Line 1439: hr_elements.check_element_freq(

1435: FOR l_parse_periods IN c_parse_periods1(p_payroll_id,
1436: TRUNC(p_end_date,l_reset),
1437: p_end_date)
1438: LOOP
1439: hr_elements.check_element_freq(
1440: p_payroll_id =>p_payroll_id,
1441: p_bg_id =>p_business_group_id,
1442: p_pay_action_id =>TO_NUMBER(null),
1443: p_date_earned =>l_parse_periods.end_date,