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 952: l_assignment_id per_assignments_f.assignment_id%TYPE;

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

Line 958: l_assignment_number per_assignments_f.assignment_number%TYPE;

954: l_sscwt_old_rate NUMBER;
955: l_periods NUMBER;
956: l_total_periods NUMBER;
957: l_employee_full_name per_people_f.full_name%TYPE;
958: l_assignment_number per_assignments_f.assignment_number%TYPE;
959: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
960: --
961: -- Cursor Declarations
962: --

Line 974: per_assignments_f assignment,

970: ,periods_in_span(service.date_start, g_financial_year
971: , assignment.assignment_id) periods
972: ,period_types.number_per_fiscal_year total_periods
973: FROM per_people_f person,
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

Line 999: ,c_assignment_id per_assignments_f.assignment_id%TYPE

995: AND NVL(service.actual_termination_date, TO_DATE('31-12-4712', 'DD-MM-YYYY'));
996:
997: --
998: CURSOR csr_assignment_action(c_financial_year DATE
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

Line 1020: ,c_assignment_id per_assignments_f.assignment_id%TYPE )

1016: --
1017: CURSOR csr_get_old_sscwt_rate
1018: (c_input_value_id pay_input_values_f.input_value_id%TYPE
1019: ,c_element_type_id pay_input_values_f.element_type_id%TYPE
1020: ,c_assignment_id per_assignments_f.assignment_id%TYPE )
1021: IS
1022: SELECT DECODE(inputv.hot_default_flag,'Y'
1023: ,NVL(entry_value.screen_entry_value, NVL(link.default_value
1024: ,inputv.default_value)),'N',entry_value.screen_entry_value) value