[Home] [Help]
918: pay_payroll_actions ppa_p35,
919: per_assignments_f paaf_p35,
920: pay_all_payrolls_f ppf_p35,
921: hr_soft_coding_keyflex flex_p35,
922: pay_action_interlocks plock
923: WHERE ppa_p35.report_type = 'IEP35'
924: AND paa_p35.action_status = 'C'
925: AND TO_CHAR ( TO_DATE (
926: pay_ie_p35.get_parameter (
1541: --11857084
1542:
1543:
1544: CURSOR get_actid_from_interlocks IS
1545: SELECT * from pay_action_interlocks
1546: where locking_action_id = p_assactid
1547: order by locking_action_id,locked_action_id desc;
1548:
1549: -- Cursor to get action type, so that we can identify whether a assignment action
1551:
1552: CURSOR get_action_type(p_action_id number)
1553: IS
1554: SELECT paa.assignment_action_id,ppa.action_type
1555: FROM pay_action_interlocks pal,
1556: pay_assignment_actions paa,
1557: pay_payroll_actions ppa
1558: WHERE pal.locked_action_id = p_action_id
1559: AND pal.locking_action_id = paa.assignment_action_id
1581:
1582: /*CURSOR csr_latest_p30_action (p_asg_act_id NUMBER)
1583: IS
1584: SELECT paa.assignment_action_id
1585: FROM pay_action_interlocks pal,
1586: pay_assignment_actions paa,
1587: pay_payroll_actions ppa,
1588: pay_action_information pai
1589: WHERE pal.locked_action_id = p_asg_act_id
1602:
1603: CURSOR csr_latest_prepay_action (p_asg_act_id NUMBER)
1604: IS
1605: SELECT paa.assignment_action_id
1606: FROM pay_action_interlocks pal,
1607: pay_assignment_actions paa,
1608: pay_payroll_actions ppa
1609: WHERE pal.locked_action_id = p_asg_act_id
1610: AND pal.locking_action_id = paa.assignment_action_id
2001: ),
2002: 0
2003: ) -- Q1_Previous_Emp_USC
2004: --14659262
2005: FROM pay_action_interlocks pai,
2006: pay_assignment_actions paa,
2007: per_people_f ppf,
2008: per_periods_of_service pps,
2009: per_assignments_f paf,