DBA Data[Home] [Help]

APPS.PER_ASG_BUS2 dependencies on PER_SHARED_TYPES

Line 1677: , per_shared_types ps

1673:
1674: cursor csr_valid_pos is
1675: select hp.business_group_id
1676: from hr_positions_f hp
1677: , per_shared_types ps
1678: where hp.position_id = p_position_id
1679: and p_validation_start_date
1680: between hp.effective_start_date
1681: and hp.effective_end_date

Line 1935: , per_shared_types ps

1931:
1932: cursor csr_valid_pos_org_comb is
1933: select null
1934: from hr_positions_f hp
1935: , per_shared_types ps
1936: where hp.position_id = p_position_id
1937: and p_validation_start_date
1938: between hp.effective_start_date
1939: and hp.effective_end_date

Line 2055: , per_shared_types ps

2051: --
2052: cursor csr_valid_pos_job_comb is
2053: select null
2054: from hr_positions_f hp
2055: , per_shared_types ps
2056: where hp.position_id = p_position_id
2057: and p_validation_start_date
2058: between hp.effective_start_date
2059: and hp.effective_end_date