DBA Data[Home] [Help]

APPS.PAY_CONTINUOUS_CALC dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1086: -- PAY_ELEMENT_ENTRY_VALUES_F

1082: hr_utility.set_location(l_proc, 900);
1083: end element_entries_ard;
1084:
1085: --------------------------------------------
1086: -- PAY_ELEMENT_ENTRY_VALUES_F
1087: --------------------------------------------
1088: /* PAY_ELEMENT_ENTRY_VALUES_F */
1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1090: purpose : This is procedure that records any changes for updates

Line 1088: /* PAY_ELEMENT_ENTRY_VALUES_F */

1084:
1085: --------------------------------------------
1086: -- PAY_ELEMENT_ENTRY_VALUES_F
1087: --------------------------------------------
1088: /* PAY_ELEMENT_ENTRY_VALUES_F */
1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1090: purpose : This is procedure that records any changes for updates
1091: on element_entry_values.
1092: */

Line 1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru

1085: --------------------------------------------
1086: -- PAY_ELEMENT_ENTRY_VALUES_F
1087: --------------------------------------------
1088: /* PAY_ELEMENT_ENTRY_VALUES_F */
1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1090: purpose : This is procedure that records any changes for updates
1091: on element_entry_values.
1092: */
1093: procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(

Line 1093: procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(

1089: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1090: purpose : This is procedure that records any changes for updates
1091: on element_entry_values.
1092: */
1093: procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(
1094: p_business_group_id in number,
1095: p_legislation_code in varchar2,
1096: p_effective_date in date,
1097: p_old_ELEMENT_ENTRY_ID in NUMBER,

Line 1113: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 10);

1109: and p_effective_date between ee.effective_start_date
1110: and ee.effective_end_date;
1111: --
1112: begin
1113: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 10);
1114: /* If the continuous calc is overriden then do nothing */
1115: if (g_override_cc = TRUE) then
1116: return;
1117: end if;

Line 1121: 'PAY_ELEMENT_ENTRY_VALUES_F',

1117: end if;
1118: --
1119: pay_continuous_calc.event_update(p_business_group_id,
1120: p_legislation_code,
1121: 'PAY_ELEMENT_ENTRY_VALUES_F',
1122: 'SCREEN_ENTRY_VALUE',
1123: p_old_SCREEN_ENTRY_VALUE,
1124: p_new_SCREEN_ENTRY_VALUE,
1125: p_effective_date,

Line 1156: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);

1152: end loop;
1153: end if;
1154: pay_continuous_calc.g_event_list.sz := 0;
1155: end;
1156: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);
1157: --
1158: end PAY_ELEMENT_ENTRY_VALUES_F_aru;
1159: --
1160:

Line 1158: end PAY_ELEMENT_ENTRY_VALUES_F_aru;

1154: pay_continuous_calc.g_event_list.sz := 0;
1155: end;
1156: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);
1157: --
1158: end PAY_ELEMENT_ENTRY_VALUES_F_aru;
1159: --
1160:
1161: --------------------------------------------
1162: -- PER_CONTRACTS_F

Line 11192: screen_val pay_element_entry_values_f.screen_entry_value%type;

11188: p_output_result out nocopy varchar2,
11189: p_date in date default null
11190: )
11191: is
11192: screen_val pay_element_entry_values_f.screen_entry_value%type;
11193: input_val pay_element_entry_values_f.input_value_id%type;
11194: --
11195: cursor do_start_chk (sk in number,
11196: ed in varchar2)

Line 11193: input_val pay_element_entry_values_f.input_value_id%type;

11189: p_date in date default null
11190: )
11191: is
11192: screen_val pay_element_entry_values_f.screen_entry_value%type;
11193: input_val pay_element_entry_values_f.input_value_id%type;
11194: --
11195: cursor do_start_chk (sk in number,
11196: ed in varchar2)
11197: is

Line 11200: from pay_element_entry_values_f

11196: ed in varchar2)
11197: is
11198: select screen_entry_value,
11199: element_entry_value_id
11200: from pay_element_entry_values_f
11201: where element_entry_id = sk
11202: and ed = effective_start_date
11203: minus
11204: select screen_entry_value,

Line 11206: from pay_element_entry_values_f

11202: and ed = effective_start_date
11203: minus
11204: select screen_entry_value,
11205: element_entry_value_id
11206: from pay_element_entry_values_f
11207: where element_entry_id = sk
11208: and ed = to_char(effective_end_date - 1);
11209: --
11210: cursor do_end_chk (sk in number,

Line 11215: from pay_element_entry_values_f

11211: ed in varchar2)
11212: is
11213: select screen_entry_value,
11214: element_entry_value_id
11215: from pay_element_entry_values_f
11216: where element_entry_id = sk
11217: and ed = effective_end_date
11218: minus
11219: select screen_entry_value,

Line 11221: from pay_element_entry_values_f

11217: and ed = effective_end_date
11218: minus
11219: select screen_entry_value,
11220: element_entry_value_id
11221: from pay_element_entry_values_f
11222: where element_entry_id = sk
11223: and ed = effective_start_date + 1;
11224: --
11225: begin

Line 11323: pay_element_entry_values_f peev,

11319: piv.default_value iv_default_value,
11320: pliv.default_value liv_default_value,
11321: peev.screen_entry_value
11322: from pay_element_entries_f pee,
11323: pay_element_entry_values_f peev,
11324: pay_element_links_f pel,
11325: pay_link_input_values_f pliv,
11326: pay_element_types_f pet,
11327: pay_input_values_f piv

Line 11393: pay_element_entry_values_f peev,

11389: piv.default_value iv_default_value,
11390: pliv.default_value liv_default_value,
11391: peev.screen_entry_value
11392: from pay_element_entries_f pee,
11393: pay_element_entry_values_f peev,
11394: pay_element_links_f pel,
11395: pay_link_input_values_f pliv,
11396: pay_element_types_f pet,
11397: pay_input_values_f piv