APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 379: -- p_assignment_id per_assignments_f.assignment_id%TYPE --

375: -- --
376: -- Parameters : --
377: -- IN : p_start_date DATE --
378: -- p_start_date DATE --
379: -- p_assignment_id per_assignments_f.assignment_id%TYPE --
380: -- --
381: -- OUT : N/A --
382: -- --
383: -- Change History : --

Line 396: , p_assignment_id IN per_assignments_f.assignment_id%TYPE)

392:
393: FUNCTION periods_in_span
394: ( p_start_date IN DATE
395: , p_end_date IN DATE
396: , p_assignment_id IN per_assignments_f.assignment_id%TYPE)
397: RETURN NUMBER
398: IS
399: --
400: l_year NUMBER(4);

Line 411: , per_assignments_f paf

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
415: AND ppa.action_type IN ('R', 'Q')

Line 593: ,per_assignments_f assignment

589: CURSOR csr_get_assignments
590: IS
591: SELECT DISTINCT assignment.assignment_id
592: FROM per_people_f person
593: ,per_assignments_f assignment
594: ,per_periods_of_service service
595: ,pay_element_types_f element
596: ,pay_element_links_f link
597: ,pay_element_entries_f entry

Line 937: l_assignment_id per_assignments_f.assignment_id%TYPE;

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;
941: l_total_periods NUMBER;

Line 943: l_assignment_number per_assignments_f.assignment_number%TYPE;

939: l_sscwt_old_rate NUMBER;
940: l_periods NUMBER;
941: l_total_periods NUMBER;
942: l_employee_full_name per_people_f.full_name%TYPE;
943: l_assignment_number per_assignments_f.assignment_number%TYPE;
944: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
945: --
946: -- Cursor Declarations
947: --

Line 959: per_assignments_f assignment,

955: ,periods_in_span(service.date_start, g_financial_year
956: , assignment.assignment_id) periods
957: ,period_types.number_per_fiscal_year total_periods
958: FROM per_people_f person,
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

Line 984: ,c_assignment_id per_assignments_f.assignment_id%TYPE

980: AND NVL(service.actual_termination_date, TO_DATE('31-12-4712', 'DD-MM-YYYY'));
981:
982: --
983: CURSOR csr_assignment_action(c_financial_year DATE
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

Line 1005: ,c_assignment_id per_assignments_f.assignment_id%TYPE )

1001: --
1002: CURSOR csr_get_old_sscwt_rate
1003: (c_input_value_id pay_input_values_f.input_value_id%TYPE
1004: ,c_element_type_id pay_input_values_f.element_type_id%TYPE
1005: ,c_assignment_id per_assignments_f.assignment_id%TYPE )
1006: IS
1007: SELECT DECODE(inputv.hot_default_flag,'Y'
1008: ,NVL(entry_value.screen_entry_value, NVL(link.default_value
1009: ,inputv.default_value)),'N',entry_value.screen_entry_value) value