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.PQP_GB_AD_EE dependencies on PER_ALL_ASSIGNMENTS_F

Line 28: FROM PER_ALL_ASSIGNMENTS_F

24:
25: -- Get ASG effective_end_date
26: SELECT effective_end_date,payroll_id
27: INTO l_asg_ed,l_asg_py_id
28: FROM PER_ALL_ASSIGNMENTS_F
29: WHERE assignment_id = p_in_asg_id
30: AND p_in_eff_date BETWEEN
31: effective_start_date
32: AND effective_end_date;

Line 107: FROM PER_ALL_ASSIGNMENTS_F

103: INTO l_bg_id
104: ,l_asg_sd
105: ,l_asg_ed
106: ,l_person_id
107: FROM PER_ALL_ASSIGNMENTS_F
108: WHERE assignment_id = p_in_asg_id
109: AND p_in_eff_date
110: BETWEEN effective_start_date AND
111: effective_end_date;

Line 143: per_all_assignments_f asg,

139: INTO l_asg_count
140: FROM pay_element_links_f pel,
141: pay_element_entries_f pee,
142: pay_element_types_f pet,
143: per_all_assignments_f asg,
144: pay_element_type_extra_info pete,
145: pay_element_entry_values_f peev,
146: pay_input_values_f piv
147: WHERE pet.element_type_id = pel.element_type_id

Line 630: FROM PER_ALL_ASSIGNMENTS_F

626:
627: -- Get ASG effective_end_date
628: SELECT effective_end_date
629: INTO l_asg_eff_ed
630: FROM PER_ALL_ASSIGNMENTS_F
631: WHERE assignment_id = p_assignment_id_o
632: AND p_effective_date BETWEEN
633: effective_start_date
634: AND effective_end_date;

Line 746: per_all_assignments_f asgt ,

742: SELECT element.element_type_id , link.element_link_id,element.business_group_id
743: FROM pay_element_types_f_tl elementtl,
744: pay_element_types_f element,
745: pay_element_links_f link,
746: per_all_assignments_f asgt ,
747: per_periods_of_service service_period
748: WHERE
749: --element.element_type_id = elementtl.element_type_id
750: -- AND elementtl.language = USERENV('LANG')

Line 949: FROM per_all_assignments_f

945: ass_attribute27,
946: ass_attribute28,
947: ass_attribute29,
948: ass_attribute30
949: FROM per_all_assignments_f
950: WHERE assignment_id = p_assignment_id
951: AND p_effective_start_date between effective_start_date and effective_end_date;
952: --
953: --Cursor to fetch Nuvos and Partnership elements

Line 997: FROM per_all_assignments_f

993: Cursor csr_get_prior_asg_dtls
994: IS
995: SELECT employment_category,
996: ass_attribute_category
997: FROM per_all_assignments_f
998: WHERE assignment_id = p_assignment_id
999: AND effective_start_date < p_effective_start_date;
1000: --
1001: */

Line 1007: FROM per_all_assignments_f

1003: --Cursor to fetch date when employee becomes Casual
1004: CURSOR csr_get_casual_asg_start_dt(c_employment_category VARCHAR2)
1005: IS
1006: SELECT MIN(effective_start_date)
1007: FROM per_all_assignments_f
1008: WHERE assignment_id = p_assignment_id
1009: AND employment_category = c_employment_category;
1010: --
1011: --Cursor to fetch element type id's for Employee since he is Casual

Line 1050: l_prior_emp_cate per_all_assignments_f.employment_category%TYPE;

1046: l_segment_value VARCHAR2(50);
1047:
1048: --For bug 7202378:Second Change
1049: l_prior_asg_dtls_query VARCHAR2(1000);
1050: l_prior_emp_cate per_all_assignments_f.employment_category%TYPE;
1051: l_prior_ass_att_cate per_all_assignments_f.ass_attribute_category%TYPE;
1052: l_prior_ass_att_xx per_all_assignments_f.ass_attribute10%TYPE;
1053: l_gde_context_flag VARCHAR2(10):= 'N';
1054:

Line 1051: l_prior_ass_att_cate per_all_assignments_f.ass_attribute_category%TYPE;

1047:
1048: --For bug 7202378:Second Change
1049: l_prior_asg_dtls_query VARCHAR2(1000);
1050: l_prior_emp_cate per_all_assignments_f.employment_category%TYPE;
1051: l_prior_ass_att_cate per_all_assignments_f.ass_attribute_category%TYPE;
1052: l_prior_ass_att_xx per_all_assignments_f.ass_attribute10%TYPE;
1053: l_gde_context_flag VARCHAR2(10):= 'N';
1054:
1055: --variables for API call(out parameters)

Line 1052: l_prior_ass_att_xx per_all_assignments_f.ass_attribute10%TYPE;

1048: --For bug 7202378:Second Change
1049: l_prior_asg_dtls_query VARCHAR2(1000);
1050: l_prior_emp_cate per_all_assignments_f.employment_category%TYPE;
1051: l_prior_ass_att_cate per_all_assignments_f.ass_attribute_category%TYPE;
1052: l_prior_ass_att_xx per_all_assignments_f.ass_attribute10%TYPE;
1053: l_gde_context_flag VARCHAR2(10):= 'N';
1054:
1055: --variables for API call(out parameters)
1056: l_object_version_number number;

Line 1122: 'from per_all_assignments_f'||' '||

1118:
1119: --check if this is a penserver employee
1120: --For bug 7202378:Logic modifed for checking penserver emp
1121: l_segment_val_query := 'select '||l_rec_get_mapped_context.pcv_information2||' '||
1122: 'from per_all_assignments_f'||' '||
1123: 'where assignment_id = '||p_assignment_id||' '||
1124: 'and to_date('''||TO_CHAR(p_effective_start_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') between effective_start_date'||' '||
1125: 'and effective_end_date';
1126:

Line 1180: 'from per_all_assignments_f'||' '||

1176:
1177: --For bug 7202378:Second Change: Modified logic
1178: l_prior_asg_dtls_query := 'select employment_category, ass_attribute_category, '||
1179: l_rec_get_mapped_context.pcv_information2||' '||
1180: 'from per_all_assignments_f'||' '||
1181: 'where assignment_id = '||p_assignment_id||' '||
1182: 'and to_date('''||TO_CHAR(p_effective_start_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') > effective_start_date';
1183:
1184: hr_utility.set_location('l_prior_asg_dtls_query: '||l_prior_asg_dtls_query,16);

Line 1286: 'from per_all_assignments_f'||' '||

1282: IF(l_prior_nuv_part_flag = 'N')
1283: THEN
1284: --Check if DFF segment column is null
1285: l_query := 'select '||l_rec_get_mapped_context.pcv_information3||' '||
1286: 'from per_all_assignments_f'||' '||
1287: 'where assignment_id = '||p_assignment_id||' '||
1288: 'and to_date('''||TO_CHAR(p_effective_start_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') between effective_start_date'||' '||
1289: 'and effective_end_date';
1290:

Line 1555: per_all_assignments_f paaf

1551: select pap.per_information10 per_agg_flag
1552: from
1553: per_all_people_f pap,
1554: pay_element_entries_f peef,
1555: per_all_assignments_f paaf
1556: where
1557: peef.element_entry_id = p_element_entry_id
1558: and paaf.assignment_id = peef.assignment_id
1559: and paaf.person_id = pap.person_id

Line 1758: per_all_assignments_f paaf

1754: select pap.per_information10 per_agg_flag
1755: from
1756: per_all_people_f pap,
1757: pay_element_entries_f peef,
1758: per_all_assignments_f paaf
1759: where
1760: peef.element_entry_id = p_element_entry_id
1761: and paaf.assignment_id = peef.assignment_id
1762: and paaf.person_id = pap.person_id

Line 1829: per_all_assignments_f paaf

1825: CURSOR tax_district(c_assignment_id in number) IS
1826: SELECT hsck.segment1
1827: FROM hr_soft_coding_keyflex hsck,
1828: pay_all_payrolls_f papf,
1829: per_all_assignments_f paaf
1830: WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
1831: AND papf.payroll_id =paaf.payroll_id
1832: AND paaf.assignment_id = c_assignment_id
1833: AND p_effective_date between paaf.effective_start_date and paaf.effective_end_date

Line 1844: per_all_assignments_f paf,

1840: SELECT pev.element_entry_id,
1841: paf.assignment_id
1842: , pev.effective_start_date --10157179
1843: FROM pay_paye_element_entries_v pev,
1844: per_all_assignments_f paf,
1845: per_assignment_status_types past
1846: WHERE pev.assignment_id = paf.assignment_id
1847: AND past.assignment_status_type_id = paf.assignment_status_type_id
1848: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN', 'TERM_ASSIGN')

Line 1856: FROM per_all_assignments_f paf

1852: AND pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_district, p_effective_date)
1853: = pay_gb_eoy_archive.get_agg_active_start(paf.assignment_id, c_tax_district, p_effective_date) */
1854: AND p_effective_date between paf.effective_start_date and paf.effective_end_date
1855: AND paf.person_id =(SELECT person_id
1856: FROM per_all_assignments_f paf
1857: WHERE assignment_id = c_assignment_id
1858: AND p_effective_date between paf.effective_start_date and paf.effective_end_date)
1859: AND c_assignment_id <> paf.assignment_id; --10157179
1860:

Line 2094: per_all_assignments_f paaf

2090:
2091: SELECT papf.per_information10
2092: INTO l_paye_agg
2093: FROM per_all_people_f papf,
2094: per_all_assignments_f paaf
2095: WHERE paaf.assignment_id = l_paye_assg_id
2096: AND paaf.person_id = papf.person_id
2097: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
2098: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;