[Home] [Help]
910: pay_payroll_actions ppa_p35,
911: per_assignments_f paaf_p35,
912: pay_all_payrolls_f ppf_p35,
913: hr_soft_coding_keyflex flex_p35,
914: pay_action_interlocks plock
915: WHERE ppa_p35.report_type = 'IEP35'
916: AND paa_p35.action_status = 'C'
917: AND TO_CHAR ( TO_DATE (
918: pay_ie_p35.get_parameter (
1236: --6633719
1237: l_dimension_name VARCHAR2(100):= '_PER_PAYE_REF_YTD';
1238:
1239: CURSOR get_actid_from_interlocks IS
1240: SELECT * from pay_action_interlocks
1241: where locking_action_id = p_assactid
1242: order by locking_action_id,locked_action_id desc;
1243:
1244: -- Cursor to get action type, so that we can identify whether a assignment action
1246:
1247: CURSOR get_action_type(p_action_id number)
1248: IS
1249: SELECT paa.assignment_action_id,ppa.action_type
1250: FROM pay_action_interlocks pal,
1251: pay_assignment_actions paa,
1252: pay_payroll_actions ppa
1253: WHERE pal.locked_action_id = p_action_id
1254: AND pal.locking_action_id = paa.assignment_action_id
1276:
1277: /*CURSOR csr_latest_p30_action (p_asg_act_id NUMBER)
1278: IS
1279: SELECT paa.assignment_action_id
1280: FROM pay_action_interlocks pal,
1281: pay_assignment_actions paa,
1282: pay_payroll_actions ppa,
1283: pay_action_information pai
1284: WHERE pal.locked_action_id = p_asg_act_id
1297:
1298: CURSOR csr_latest_prepay_action (p_asg_act_id NUMBER)
1299: IS
1300: SELECT paa.assignment_action_id
1301: FROM pay_action_interlocks pal,
1302: pay_assignment_actions paa,
1303: pay_payroll_actions ppa
1304: WHERE pal.locked_action_id = p_asg_act_id
1305: AND pal.locking_action_id = paa.assignment_action_id
1628: 2
1629: ),
1630: 0
1631: ) -- Q1_Previous_Emp_Tax
1632: FROM pay_action_interlocks pai,
1633: pay_assignment_actions paa,
1634: per_people_f ppf,
1635: per_periods_of_service pps,
1636: per_assignments_f paf,