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 951: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

947: l_yearly_value NUMBER ;
948: l_action_info_id NUMBER ;
949: l_ovn NUMBER ;
950:
951: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
952: l_assignment_id per_assignments_f.assignment_id%TYPE;
953: l_sscwt_new_rate NUMBER;
954: l_sscwt_old_rate NUMBER;
955: l_periods NUMBER;

Line 964: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE

960: --
961: -- Cursor Declarations
962: --
963: CURSOR csr_employees
964: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
965: ,c_business_group_id per_people_f.business_group_id%TYPE)
966: IS
967: SELECT person.full_name
968: ,assignment.assignment_number

Line 978: pay_assignment_actions actions

974: per_assignments_f assignment,
975: per_periods_of_service service,
976: pay_payrolls_f payroll,
977: per_time_period_types period_types,
978: pay_assignment_actions actions
979: WHERE person.business_group_id = c_business_group_id
980: AND actions.assignment_action_id = c_assignment_action_id
981: AND assignment.assignment_id = actions.assignment_id
982: AND assignment.person_id = person.person_id

Line 1003: FROM pay_assignment_actions max_asg_act

999: ,c_assignment_id per_assignments_f.assignment_id%TYPE
1000: )
1001: IS
1002: SELECT max_asg_act.assignment_action_id
1003: FROM pay_assignment_actions max_asg_act
1004: WHERE max_asg_act.assignment_id = c_assignment_id
1005: AND max_asg_act.action_sequence = (
1006: SELECT max(asg_action.action_sequence) action_sequence
1007: FROM pay_assignment_actions asg_action,

Line 1007: FROM pay_assignment_actions asg_action,

1003: FROM pay_assignment_actions max_asg_act
1004: WHERE max_asg_act.assignment_id = c_assignment_id
1005: AND max_asg_act.action_sequence = (
1006: SELECT max(asg_action.action_sequence) action_sequence
1007: FROM pay_assignment_actions asg_action,
1008: pay_payroll_actions pay_action
1009: WHERE asg_action.assignment_id = c_assignment_id
1010: AND asg_action.payroll_action_id = pay_action.payroll_action_id
1011: AND asg_action.action_status = 'C'