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_ASSIGNMENT_STATUS_TYPES

Line 65: l_active_assign per_assignment_status_types.per_system_status%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
69: select min(papf.effective_start_date)

Line 66: l_susp_assign per_assignment_status_types.per_system_status%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
69: select min(papf.effective_start_date)
70: from per_all_people_f papf,

Line 81: per_assignment_status_types past

77: cursor csr_asg_date is
78: select min(effective_start_date)
79: from per_all_assignments_f paaf,
80: hr_soft_coding_keyflex scl,
81: per_assignment_status_types past
82: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
83: and paaf.SOFT_CODING_KEYFLEX_ID = scl.SOFT_CODING_KEYFLEX_ID
84: and scl.segment3 = p_contract_category
85: and paaf.assignment_id = p_per_or_asg_id

Line 769: l_assg_type1 per_assignment_status_types.per_system_status%TYPE;

765: l_norm_term pay_pl_sii_details_f.contract_category%TYPE;
766: l_norm_active pay_pl_sii_details_f.contract_category%TYPE;
767: l_exists pay_pl_sii_details_f.per_or_asg_id%TYPE;
768:
769: l_assg_type1 per_assignment_status_types.per_system_status%TYPE;
770: l_assg_type2 per_assignment_status_types.per_system_status%TYPE;
771: l_flag varchar2(1);
772:
773: cursor csr_term_catg(p_contract_catg char) is

Line 770: l_assg_type2 per_assignment_status_types.per_system_status%TYPE;

766: l_norm_active pay_pl_sii_details_f.contract_category%TYPE;
767: l_exists pay_pl_sii_details_f.per_or_asg_id%TYPE;
768:
769: l_assg_type1 per_assignment_status_types.per_system_status%TYPE;
770: l_assg_type2 per_assignment_status_types.per_system_status%TYPE;
771: l_flag varchar2(1);
772:
773: cursor csr_term_catg(p_contract_catg char) is
774: select per_or_asg_id from pay_pl_sii_details_f

Line 784: per_assignment_status_types pst,

780: select soft1.segment4 contract_type1, soft2.segment4 contract_type2
781: from hr_soft_coding_keyflex soft1,
782: per_all_assignments_f paf1,
783: per_all_people_f pap,
784: per_assignment_status_types pst,
785: hr_soft_coding_keyflex soft2,
786: per_all_assignments_f paf2
787: where pap.person_id = (select per_or_asg_id from pay_pl_sii_details_f
788: where sii_details_id = p_sii_details_id and