DBA Data[Home] [Help]

APPS.PER_ASG_BUS2 dependencies on PER_SHARED_TYPES

Line 1637: , per_shared_types ps

1633:
1634: cursor csr_valid_pos is
1635: select hp.business_group_id
1636: from hr_positions_f hp
1637: , per_shared_types ps
1638: where hp.position_id = p_position_id
1639: and p_validation_start_date
1640: between hp.effective_start_date
1641: and hp.effective_end_date

Line 1895: , per_shared_types ps

1891:
1892: cursor csr_valid_pos_org_comb is
1893: select null
1894: from hr_positions_f hp
1895: , per_shared_types ps
1896: where hp.position_id = p_position_id
1897: and p_validation_start_date
1898: between hp.effective_start_date
1899: and hp.effective_end_date

Line 2015: , per_shared_types ps

2011: --
2012: cursor csr_valid_pos_job_comb is
2013: select null
2014: from hr_positions_f hp
2015: , per_shared_types ps
2016: where hp.position_id = p_position_id
2017: and p_validation_start_date
2018: between hp.effective_start_date
2019: and hp.effective_end_date