eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SOE_GLB dependencies on PAY_ELEMENT_ENTRIES_F

Line 260: ,pay_element_entries_f ee

256: ,ppb2.business_group_id
257: ,ee.assignment_id
258: ,eev.screen_entry_value salary
259: from per_pay_bases ppb2
260: ,pay_element_entries_f ee
261: ,pay_element_entry_values_f eev
262: where ppb2.input_value_id = eev.input_value_id
263: and ee.element_entry_id = eev.element_entry_id
264: and :effective_date between ee.effective_start_date

Line 1137: ( p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1133: -- date_earned
1134: ---------------------------------------------------------------------------
1135:
1136: function get_retro_period
1137: ( p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1138: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1139: p_call_type in integer -- if 0 then return the period, 1 retro_start, 2 retro_end
1140: ) return varchar2 is
1141:

Line 1142: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1138: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1139: p_call_type in integer -- if 0 then return the period, 1 retro_start, 2 retro_end
1140: ) return varchar2 is
1141:
1142: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1143: c_date_earned in pay_payroll_actions.date_earned%TYPE
1144: ) is
1145: SELECT creator_type
1146: FROM pay_element_entries_f pee

Line 1146: FROM pay_element_entries_f pee

1142: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1143: c_date_earned in pay_payroll_actions.date_earned%TYPE
1144: ) is
1145: SELECT creator_type
1146: FROM pay_element_entries_f pee
1147: WHERE pee.element_entry_id=c_element_entry_id
1148: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1149:
1150:

Line 1152: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1148: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1149:
1150:
1151: cursor get_retro_period_rr
1152: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1153: c_date_earned in pay_payroll_actions.date_earned%TYPE
1154: ) is
1155:
1156: SELECT ptp.start_date

Line 1163: pay_element_entries_f pee

1159: FROM per_time_periods ptp,
1160: pay_payroll_actions ppa,
1161: pay_assignment_actions paa,
1162: pay_run_results prr,
1163: pay_element_entries_f pee
1164: WHERE pee.element_entry_id=c_element_entry_id
1165: and prr.run_result_id = pee.source_id
1166: and paa.assignment_action_id=prr.assignment_action_id
1167: and ppa.payroll_action_id=paa.payroll_action_id

Line 1175: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1171: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1172:
1173:
1174: cursor get_retro_period_nr
1175: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1176: c_date_earned in pay_payroll_actions.date_earned%TYPE
1177: ) is
1178: SELECT ptp.start_date
1179: ,ptp.end_date

Line 1185: pay_element_entries_f pee

1181: FROM per_time_periods ptp,
1182: pay_payroll_actions ppa,
1183: pay_assignment_actions paa,
1184: pay_run_results prr,
1185: pay_element_entries_f pee
1186: WHERE pee.element_entry_id=c_element_entry_id
1187: and prr.run_result_id = pee.source_id
1188: and paa.assignment_action_id=prr.assignment_action_id
1189: and ppa.payroll_action_id=paa.payroll_action_id

Line 1197: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1193: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1194:
1195:
1196: cursor get_retro_period_pr
1197: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1198: c_date_earned in pay_payroll_actions.date_earned%TYPE
1199: ) is
1200: SELECT ptp.start_date
1201: ,ptp.end_date

Line 1207: pay_element_entries_f pee

1203: FROM per_time_periods ptp,
1204: pay_payroll_actions ppa,
1205: pay_assignment_actions paa,
1206: pay_run_results prr,
1207: pay_element_entries_f pee
1208: WHERE pee.element_entry_id=c_element_entry_id
1209: and prr.run_result_id = pee.source_id
1210: and paa.assignment_action_id=prr.assignment_action_id
1211: and ppa.payroll_action_id=paa.payroll_action_id

Line 1219: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

1215: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1216:
1217:
1218: cursor get_retro_period_ee
1219: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1220: c_date_earned in pay_payroll_actions.date_earned%TYPE
1221: ) is
1222: SELECT ptp.start_date
1223: ,ptp.end_date

Line 1228: pay_element_entries_f pee

1224: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1225: FROM per_time_periods ptp,
1226: pay_payroll_actions ppa,
1227: pay_assignment_actions paa,
1228: pay_element_entries_f pee
1229: WHERE pee.element_entry_id=c_element_entry_id
1230: and paa.assignment_action_id=pee.source_asg_action_id
1231: and ppa.payroll_action_id=paa.payroll_action_id
1232: and ptp.payroll_id=ppa.payroll_id

Line 1237: l_creator_type pay_element_entries_f.creator_type%TYPE;

1233: and pee.creator_type='EE'
1234: and ppa.date_earned between ptp.start_date and ptp.end_date
1235: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
1236:
1237: l_creator_type pay_element_entries_f.creator_type%TYPE;
1238: l_period_obtained_flag number;
1239: l_retro_start_date date;
1240: l_retro_end_date date;
1241: l_period_num_year varchar2(30) :=null;