[Home] [Help]
395: IS
396:
397: CURSOR cur_nat_min_wg
398: IS
399: SELECT fnd_number.canonical_to_number(global_value)
400: FROM ff_globals_f
401: WHERE GLOBAL_NAME = 'IE_NAT_MIN_WAGE_RATE'
402: AND legislation_code = 'IE'
403: AND g_archive_effective_date BETWEEN effective_start_date AND effective_end_date;
1204:
1205:
1206: CURSOR cur_assignment_action(c_person_id number,
1207: c_till_date date)is
1208: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1209: paa.assignment_action_id),16))
1210: FROM pay_assignment_actions paa
1211: ,pay_payroll_actions ppa
1212: ,per_all_assignments_f paaf
1223: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1224: AND scl.segment4 = to_char(g_employer_id);
1225:
1226: CURSOR cur_assignment_action_ytd(c_person_id number)is
1227: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1228: paa.assignment_action_id),16))
1229: FROM pay_assignment_actions paa
1230: ,pay_payroll_actions ppa
1231: ,per_all_assignments_f paaf
1367:
1368: CURSOR cur_assignment_action_ppsn(c_person_id number,
1369: c_till_date date,
1370: c_ppsn_override per_assignment_extra_info.aei_information1%type)is
1371: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1372: paa.assignment_action_id),16))
1373: FROM pay_assignment_actions paa
1374: ,pay_payroll_actions ppa
1375: ,per_all_assignments_f paaf
1393: AND scl.segment4 = to_char(g_employer_id);
1394:
1395: CURSOR cur_assignment_action_ytd_ppsn(c_person_id number,
1396: c_ppsn_override per_assignment_extra_info.aei_information1%type)is
1397: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1398: paa.assignment_action_id),16))
1399: FROM pay_assignment_actions paa
1400: ,pay_payroll_actions ppa
1401: ,per_all_assignments_f paaf