APPS.PER_US_IPEDS_PKG dependencies on PER_PAY_BASES

Line 218: ,per_pay_bases ppb

214: ,per_all_assignments_f asg
215: ,per_assignment_status_types ast
216: ,per_jobs job
217: ,per_pay_proposals ppp
218: ,per_pay_bases ppb
219: ,per_people_extra_info ppea
220: ,per_people_extra_info ppet
221: WHERE peo.person_id = asg.person_id
222: AND peo.person_id = ppea.person_id

Line 337: ,per_pay_bases ppb

333: ,per_all_assignments_f asg
334: ,per_assignment_status_types ast
335: ,per_jobs job
336: ,per_pay_proposals ppp
337: ,per_pay_bases ppb
338: ,per_people_extra_info ppea
339: ,per_people_extra_info ppet
340: ,per_contracts_f pco
341: ,per_shared_types pst

Line 464: ,per_pay_bases ppb

460: ,per_all_assignments_f asg
461: ,per_assignment_status_types ast
462: ,per_jobs job
463: ,per_pay_proposals ppp
464: ,per_pay_bases ppb
465: WHERE peo.person_id = asg.person_id
466: AND peo.current_employee_flag = 'Y'
467: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
468: AND job.business_group_id = p_business_group_id

Line 578: ,per_pay_bases ppb

574: ,per_all_assignments_f asg
575: ,per_assignment_status_types ast
576: ,per_jobs job
577: ,per_pay_proposals ppp
578: ,per_pay_bases ppb
579: ,per_people_extra_info ppea
580: ,per_contracts_f pco
581: ,per_shared_types pst
582: ,per_shared_types pst1

Line 700: ,per_pay_bases ppb

696: ,per_all_assignments_f asg
697: ,per_assignment_status_types ast
698: ,per_jobs job
699: ,per_pay_proposals ppp
700: ,per_pay_bases ppb
701: WHERE peo.person_id = asg.person_id
702: AND peo.current_employee_flag = 'Y'
703: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
704: AND job.business_group_id = p_business_group_id

Line 850: ,per_pay_bases ppb

846: ,per_all_assignments_f asg
847: ,per_assignment_status_types ast
848: ,per_jobs job
849: ,per_pay_proposals ppp
850: ,per_pay_bases ppb
851: ,per_people_extra_info ppet
852: WHERE peo.person_id = asg.person_id
853: AND peo.person_id = ppet.person_id
854: AND ppet.information_type = 'PQH_TENURE_STATUS'

Line 960: ,per_pay_bases ppb

956: ,per_all_assignments_f asg
957: ,per_assignment_status_types ast
958: ,per_jobs job
959: ,per_pay_proposals ppp
960: ,per_pay_bases ppb
961: ,per_people_extra_info ppet
962: ,per_contracts_f pco
963: ,per_shared_types pst
964: ,per_shared_types pst1

Line 1077: ,per_pay_bases ppb

1073: ,per_all_assignments_f asg
1074: ,per_assignment_status_types ast
1075: ,per_jobs job
1076: ,per_pay_proposals ppp
1077: ,per_pay_bases ppb
1078: WHERE peo.person_id = asg.person_id
1079: AND peo.current_employee_flag = 'Y'
1080: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = l_emp_category
1081: AND job.job_information_category = 'US'

Line 1189: ,per_pay_bases ppb

1185: ,per_all_assignments_f asg
1186: ,per_assignment_status_types ast
1187: ,per_jobs job
1188: ,per_pay_proposals ppp
1189: ,per_pay_bases ppb
1190: ,per_contracts_f pco
1191: ,per_shared_types pst
1192: ,per_shared_types pst1
1193: WHERE peo.person_id = asg.person_id

Line 1303: ,per_pay_bases ppb

1299: ,per_all_assignments_f asg
1300: ,per_assignment_status_types ast
1301: ,per_jobs job
1302: ,per_pay_proposals ppp
1303: ,per_pay_bases ppb
1304: WHERE peo.person_id = asg.person_id
1305: AND peo.current_employee_flag = 'Y'
1306: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = l_emp_category
1307: AND job.job_information_category = 'US'

Line 1430: ,per_pay_bases ppb

1426: ,per_all_assignments_f asg
1427: ,per_assignment_status_types ast
1428: ,per_jobs job
1429: ,per_pay_proposals ppp
1430: ,per_pay_bases ppb
1431: WHERE peo.person_id = asg.person_id
1432: AND peo.current_employee_flag = 'Y'
1433: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'PR'
1434: AND job.job_information_category = 'US'

Line 1532: ,per_pay_bases ppb

1528: ,per_all_assignments_f asg
1529: ,per_assignment_status_types ast
1530: ,per_jobs job
1531: ,per_pay_proposals ppp
1532: ,per_pay_bases ppb
1533: ,per_people_extra_info ppea
1534: ,per_contracts_f pco
1535: ,per_shared_types pst
1536: ,per_shared_types pst1

Line 1603: ,per_pay_bases ppb

1599: ,per_all_assignments_f asg
1600: ,per_assignment_status_types ast
1601: ,per_jobs job
1602: ,per_pay_proposals ppp
1603: ,per_pay_bases ppb
1604: WHERE peo.person_id = asg.person_id
1605: AND peo.current_employee_flag = 'Y'
1606: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
1607: AND job.business_group_id = p_business_group_id

Line 1728: ,per_pay_bases ppb

1724: ,per_all_assignments_f asg
1725: ,per_assignment_status_types ast
1726: ,per_jobs job
1727: ,per_pay_proposals ppp
1728: ,per_pay_bases ppb
1729: ,per_people_extra_info ppet
1730: ,per_periods_of_service pps
1731: WHERE peo.person_id = asg.person_id
1732: AND peo.person_id = ppet.person_id

Line 1840: ,per_pay_bases ppb

1836: ,per_all_assignments_f asg
1837: ,per_assignment_status_types ast
1838: ,per_jobs job
1839: ,per_pay_proposals ppp
1840: ,per_pay_bases ppb
1841: ,per_people_extra_info ppet
1842: ,per_contracts_f pco
1843: ,per_shared_types pst
1844: ,per_shared_types pst1

Line 1960: ,per_pay_bases ppb

1956: ,per_all_assignments_f asg
1957: ,per_assignment_status_types ast
1958: ,per_jobs job
1959: ,per_pay_proposals ppp
1960: ,per_pay_bases ppb
1961: ,per_periods_of_service pps
1962: WHERE peo.person_id = asg.person_id
1963: AND peo.current_employee_flag = 'Y'
1964: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 2073: ,per_pay_bases ppb

2069: ,per_all_assignments_f asg
2070: ,per_assignment_status_types ast
2071: ,per_jobs job
2072: ,per_pay_proposals ppp
2073: ,per_pay_bases ppb
2074: ,per_contracts_f pco
2075: ,per_shared_types pst
2076: ,per_shared_types pst1
2077: ,per_periods_of_service pps

Line 2188: ,per_pay_bases ppb

2184: ,per_all_assignments_f asg
2185: ,per_assignment_status_types ast
2186: ,per_jobs job
2187: ,per_pay_proposals ppp
2188: ,per_pay_bases ppb
2189: ,per_periods_of_service pps
2190: WHERE peo.person_id = asg.person_id
2191: AND peo.current_employee_flag = 'Y'
2192: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 2295: ,per_pay_bases ppb

2291: ,per_all_assignments_f asg
2292: ,per_assignment_status_types ast
2293: ,per_jobs job
2294: ,per_pay_proposals ppp
2295: ,per_pay_bases ppb
2296: ,per_periods_of_service pps
2297: WHERE peo.person_id = asg.person_id
2298: AND peo.current_employee_flag = 'Y'
2299: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 2430: ,per_pay_bases ppb

2426: ,per_all_assignments_f asg
2427: ,per_assignment_status_types ast
2428: ,per_jobs job
2429: ,per_pay_proposals ppp
2430: ,per_pay_bases ppb
2431: WHERE peo.person_id = asg.person_id
2432: AND peo.current_employee_flag = 'Y'
2433: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = l_employment_category
2434: AND job.business_group_id = p_business_group_id