DBA Data[Home] [Help]

APPS.PAY_CONTINUOUS_CALC dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1118: -- PAY_ELEMENT_ENTRY_VALUES_F

1114: hr_utility.set_location(l_proc, 900);
1115: end element_entries_ard;
1116:
1117: --------------------------------------------
1118: -- PAY_ELEMENT_ENTRY_VALUES_F
1119: --------------------------------------------
1120: /* PAY_ELEMENT_ENTRY_VALUES_F */
1121: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1122: purpose : This is procedure that records any changes for updates

Line 1120: /* PAY_ELEMENT_ENTRY_VALUES_F */

1116:
1117: --------------------------------------------
1118: -- PAY_ELEMENT_ENTRY_VALUES_F
1119: --------------------------------------------
1120: /* PAY_ELEMENT_ENTRY_VALUES_F */
1121: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1122: purpose : This is procedure that records any changes for updates
1123: on element_entry_values.
1124: */

Line 1121: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru

1117: --------------------------------------------
1118: -- PAY_ELEMENT_ENTRY_VALUES_F
1119: --------------------------------------------
1120: /* PAY_ELEMENT_ENTRY_VALUES_F */
1121: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1122: purpose : This is procedure that records any changes for updates
1123: on element_entry_values.
1124: */
1125: procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(

Line 1125: procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(

1121: /* name : PAY_ELEMENT_ENTRY_VALUES_F_aru
1122: purpose : This is procedure that records any changes for updates
1123: on element_entry_values.
1124: */
1125: procedure PAY_ELEMENT_ENTRY_VALUES_F_aru(
1126: p_business_group_id in number,
1127: p_legislation_code in varchar2,
1128: p_effective_date in date,
1129: p_old_ELEMENT_ENTRY_ID in NUMBER,

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

1141: and p_effective_date between ee.effective_start_date
1142: and ee.effective_end_date;
1143: --
1144: begin
1145: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 10);
1146: /* If the continuous calc is overriden then do nothing */
1147: if (g_override_cc = TRUE) then
1148: return;
1149: end if;

Line 1153: 'PAY_ELEMENT_ENTRY_VALUES_F',

1149: end if;
1150: --
1151: pay_continuous_calc.event_update(p_business_group_id,
1152: p_legislation_code,
1153: 'PAY_ELEMENT_ENTRY_VALUES_F',
1154: 'SCREEN_ENTRY_VALUE',
1155: p_old_SCREEN_ENTRY_VALUE,
1156: p_new_SCREEN_ENTRY_VALUE,
1157: p_effective_date,

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

1184: end loop;
1185: end if;
1186: pay_continuous_calc.g_event_list.sz := 0;
1187: end;
1188: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);
1189: --
1190: end PAY_ELEMENT_ENTRY_VALUES_F_aru;
1191: --
1192:

Line 1190: end PAY_ELEMENT_ENTRY_VALUES_F_aru;

1186: pay_continuous_calc.g_event_list.sz := 0;
1187: end;
1188: hr_utility.set_location('pay_cc_dyt_code_pkg.PAY_ELEMENT_ENTRY_VALUES_F_aru', 50);
1189: --
1190: end PAY_ELEMENT_ENTRY_VALUES_F_aru;
1191: --
1192:
1193: --------------------------------------------
1194: -- PER_CONTRACTS_F

Line 11224: screen_val pay_element_entry_values_f.screen_entry_value%type;

11220: p_output_result out nocopy varchar2,
11221: p_date in date default null
11222: )
11223: is
11224: screen_val pay_element_entry_values_f.screen_entry_value%type;
11225: input_val pay_element_entry_values_f.input_value_id%type;
11226: --
11227: cursor do_start_chk (sk in number,
11228: ed in varchar2)

Line 11225: input_val pay_element_entry_values_f.input_value_id%type;

11221: p_date in date default null
11222: )
11223: is
11224: screen_val pay_element_entry_values_f.screen_entry_value%type;
11225: input_val pay_element_entry_values_f.input_value_id%type;
11226: --
11227: cursor do_start_chk (sk in number,
11228: ed in varchar2)
11229: is

Line 11232: from pay_element_entry_values_f

11228: ed in varchar2)
11229: is
11230: select screen_entry_value,
11231: element_entry_value_id
11232: from pay_element_entry_values_f
11233: where element_entry_id = sk
11234: and ed = effective_start_date
11235: minus
11236: select screen_entry_value,

Line 11238: from pay_element_entry_values_f

11234: and ed = effective_start_date
11235: minus
11236: select screen_entry_value,
11237: element_entry_value_id
11238: from pay_element_entry_values_f
11239: where element_entry_id = sk
11240: and ed = to_char(effective_end_date - 1);
11241: --
11242: cursor do_end_chk (sk in number,

Line 11247: from pay_element_entry_values_f

11243: ed in varchar2)
11244: is
11245: select screen_entry_value,
11246: element_entry_value_id
11247: from pay_element_entry_values_f
11248: where element_entry_id = sk
11249: and ed = effective_end_date
11250: minus
11251: select screen_entry_value,

Line 11253: from pay_element_entry_values_f

11249: and ed = effective_end_date
11250: minus
11251: select screen_entry_value,
11252: element_entry_value_id
11253: from pay_element_entry_values_f
11254: where element_entry_id = sk
11255: and ed = effective_start_date + 1;
11256: --
11257: begin

Line 11355: pay_element_entry_values_f peev,

11351: piv.default_value iv_default_value,
11352: pliv.default_value liv_default_value,
11353: peev.screen_entry_value
11354: from pay_element_entries_f pee,
11355: pay_element_entry_values_f peev,
11356: pay_element_links_f pel,
11357: pay_link_input_values_f pliv,
11358: pay_element_types_f pet,
11359: pay_input_values_f piv

Line 11425: pay_element_entry_values_f peev,

11421: piv.default_value iv_default_value,
11422: pliv.default_value liv_default_value,
11423: peev.screen_entry_value
11424: from pay_element_entries_f pee,
11425: pay_element_entry_values_f peev,
11426: pay_element_links_f pel,
11427: pay_link_input_values_f pliv,
11428: pay_element_types_f pet,
11429: pay_input_values_f piv