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_PL_SII_API dependencies on PER_PERSON_TYPES

Line 63: l_emp per_person_types.system_person_type%TYPE;

59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;
60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;
61: l_unemployment_contribution pay_pl_sii_details_f.unemployment_contribution%type;
62:
63: l_emp per_person_types.system_person_type%TYPE;
64: l_emp_apl per_person_types.system_person_type%TYPE;
65: l_active_assign per_assignment_status_types.per_system_status%TYPE;
66: l_susp_assign per_assignment_status_types.per_system_status%TYPE;
67:

Line 64: l_emp_apl per_person_types.system_person_type%TYPE;

60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;
61: l_unemployment_contribution pay_pl_sii_details_f.unemployment_contribution%type;
62:
63: l_emp per_person_types.system_person_type%TYPE;
64: l_emp_apl per_person_types.system_person_type%TYPE;
65: l_active_assign per_assignment_status_types.per_system_status%TYPE;
66: l_susp_assign per_assignment_status_types.per_system_status%TYPE;
67:
68: cursor csr_per_date is

Line 71: per_person_types ppt

67:
68: cursor csr_per_date is
69: select min(papf.effective_start_date)
70: from per_all_people_f papf,
71: per_person_types ppt
72: where papf.person_type_id = ppt.person_type_id
73: and system_person_type in (l_emp,l_emp_apl)
74: and papf.person_id = p_per_or_asg_id
75: and papf.business_group_id = p_business_group_id;