eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_PRE_TAX_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,

62: p_errbuf OUT NOCOPY VARCHAR2,
63: p_retcode OUT NOCOPY VARCHAR2,
64: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,
67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,
70: p_actual_termination_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE,

Line 67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,

63: p_retcode OUT NOCOPY VARCHAR2,
64: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,
67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,
70: p_actual_termination_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE,
71: p_employment_category OUT NOCOPY per_all_assignments_f.employment_category%TYPE)

Line 71: p_employment_category OUT NOCOPY per_all_assignments_f.employment_category%TYPE)

67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,
70: p_actual_termination_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE,
71: p_employment_category OUT NOCOPY per_all_assignments_f.employment_category%TYPE)
72: IS
73:
74: BEGIN
75:

Line 90: from per_all_assignments_f asg,

86: p_date_start,
87: p_leaving_reason,
88: p_actual_termination_date,
89: p_employment_category
90: from per_all_assignments_f asg,
91: per_periods_of_service pds
92: where asg.assignment_id = p_assignment_id
93: and p_effective_date between asg.effective_start_date and asg.effective_end_date
94: and pds.period_of_service_id = asg.period_of_service_id;

Line 118: l_person_id per_all_assignments_f.person_id%TYPE;

114: p_value IN pay_jp_custom_pkg.value_rec)
115: IS
116: l_action_status VARCHAR2(1);
117: l_message VARCHAR2(255);
118: l_person_id per_all_assignments_f.person_id%TYPE;
119: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
120: l_date_start per_periods_of_service.date_start%TYPE;
121: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 119: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

115: IS
116: l_action_status VARCHAR2(1);
117: l_message VARCHAR2(255);
118: l_person_id per_all_assignments_f.person_id%TYPE;
119: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
120: l_date_start per_periods_of_service.date_start%TYPE;
121: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
123: l_employment_category per_all_assignments_f.employment_category%TYPE;

Line 123: l_employment_category per_all_assignments_f.employment_category%TYPE;

119: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
120: l_date_start per_periods_of_service.date_start%TYPE;
121: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
123: l_employment_category per_all_assignments_f.employment_category%TYPE;
124:
125: l_action_info_id1 pay_action_information.action_information_id%TYPE;
126: l_action_info_id2 pay_action_information.action_information_id%TYPE;
127: l_ovn pay_action_information.object_version_number%TYPE;

Line 580: FROM per_all_assignments_f

576: AND pai.assignment_id = p_assignment_id;
577:
578: CURSOR csr_asgset_assact IS
579: SELECT DISTINCT ASSIGNMENT_ID
580: FROM per_all_assignments_f
581: WHERE l_from_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
582: OR l_to_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
583: AND PAYROLL_ID = p_payroll_id
584: AND BUSINESS_GROUP_ID = p_business_group_id;

Line 587: assignment_id per_all_assignments_f.assignment_id%TYPE);

583: AND PAYROLL_ID = p_payroll_id
584: AND BUSINESS_GROUP_ID = p_business_group_id;
585:
586: TYPE t_temp_rec IS RECORD(
587: assignment_id per_all_assignments_f.assignment_id%TYPE);
588:
589: TYPE t_temp_table IS TABLE OF t_temp_rec
590: INDEX BY BINARY_INTEGER;
591: