APPS.PAY_JP_IWHT_ARCH_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 377: FUNCTION get_with_hold_agent(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

373: RAISE;
374: RETURN NULL;
375: END proc_lookup_meaning;
376: --
377: FUNCTION get_with_hold_agent(p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
378: ,p_effective_date IN DATE)
379: --************************************************************************
380: -- FUNCTION
381: -- pay_balance_result_value

Line 436: PROCEDURE delete_assact ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE)

432: RAISE;
433: RETURN NULL;
434: END get_with_hold_agent;
435: --
436: PROCEDURE delete_assact ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE)
437: --***************************************************************************
438: -- PROCEDURE
439: -- DELETE_ASSACT
440: --

Line 462: CURSOR lcu_action_information_id(p_assignment_id per_all_assignments_f.assignment_id%TYPE)

458: -- None
459: --***********************************************************************
460: IS
461: -- Local Variables
462: CURSOR lcu_action_information_id(p_assignment_id per_all_assignments_f.assignment_id%TYPE)
463: IS
464: SELECT PAI.object_version_number
465: ,PAI.action_information_id
466: ,PAC.assignment_action_id

Line 945: CURSOR lcu_employee_details ( p_assignment_id per_all_assignments_f.assignment_id%TYPE

941: SELECT assignment_id
942: FROM pay_assignment_actions
943: WHERE assignment_action_id = p_assignment_action_id;
944: --
945: CURSOR lcu_employee_details ( p_assignment_id per_all_assignments_f.assignment_id%TYPE
946: , p_effective_date DATE
947: )
948: IS
949: SELECT PPF.person_id person_id

Line 1117: CURSOR lcu_prev_archive (p_assignment_id per_all_assignments_f.assignment_id%TYPE)

1113: ||' - '||
1114: TO_CHAR(p_end_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''')
1115: FROM dual;
1116: --
1117: CURSOR lcu_prev_archive (p_assignment_id per_all_assignments_f.assignment_id%TYPE)
1118: IS
1119: SELECT 'Y'
1120: FROM pay_action_information PAI
1121: ,pay_assignment_actions PAC

Line 1159: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

1155: ln_action_info_id pay_action_information.action_information_id%TYPE;
1156: ln_obj_version_num pay_action_information.object_version_number%TYPE;
1157: ln_tax_action_info_id pay_action_information.action_information_id%TYPE;
1158: ln_tax_obj_version_num pay_action_information.object_version_number%TYPE;
1159: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
1160: ln_service_years NUMBER;
1161: ln_termination_money NUMBER;
1162: ln_withholidng_tax NUMBER;
1163: ln_muncipal_tax NUMBER;