APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 410: , pay_assignment_actions paa

406: IS
407: SELECT count(*)
408: FROM pay_payroll_actions ppa
409: , per_time_periods ptp
410: , pay_assignment_actions paa
411: , per_assignments_f paf
412: , pay_payrolls_f ppf
413: WHERE paa.assignment_id = paf.assignment_id
414: AND paa.payroll_action_id = ppa.payroll_action_id

Line 586: SELECT pay_assignment_actions_s.nextval FROM dual;

582:
583:
584: CURSOR csr_next_action_id
585: IS
586: SELECT pay_assignment_actions_s.nextval FROM dual;
587:
588:
589: CURSOR csr_get_assignments
590: IS

Line 936: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

932: l_yearly_value NUMBER ;
933: l_action_info_id NUMBER ;
934: l_ovn NUMBER ;
935:
936: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
937: l_assignment_id per_assignments_f.assignment_id%TYPE;
938: l_sscwt_new_rate NUMBER;
939: l_sscwt_old_rate NUMBER;
940: l_periods NUMBER;

Line 949: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE

945: --
946: -- Cursor Declarations
947: --
948: CURSOR csr_employees
949: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
950: ,c_business_group_id per_people_f.business_group_id%TYPE)
951: IS
952: SELECT person.full_name
953: ,assignment.assignment_number

Line 963: pay_assignment_actions actions

959: per_assignments_f assignment,
960: per_periods_of_service service,
961: pay_payrolls_f payroll,
962: per_time_period_types period_types,
963: pay_assignment_actions actions
964: WHERE person.business_group_id = c_business_group_id
965: AND actions.assignment_action_id = c_assignment_action_id
966: AND assignment.assignment_id = actions.assignment_id
967: AND assignment.person_id = person.person_id

Line 988: FROM pay_assignment_actions max_asg_act

984: ,c_assignment_id per_assignments_f.assignment_id%TYPE
985: )
986: IS
987: SELECT max_asg_act.assignment_action_id
988: FROM pay_assignment_actions max_asg_act
989: WHERE max_asg_act.assignment_id = c_assignment_id
990: AND max_asg_act.action_sequence = (
991: SELECT max(asg_action.action_sequence) action_sequence
992: FROM pay_assignment_actions asg_action,

Line 992: FROM pay_assignment_actions asg_action,

988: FROM pay_assignment_actions max_asg_act
989: WHERE max_asg_act.assignment_id = c_assignment_id
990: AND max_asg_act.action_sequence = (
991: SELECT max(asg_action.action_sequence) action_sequence
992: FROM pay_assignment_actions asg_action,
993: pay_payroll_actions pay_action
994: WHERE asg_action.assignment_id = c_assignment_id
995: AND asg_action.payroll_action_id = pay_action.payroll_action_id
996: AND asg_action.action_status = 'C'