DBA Data[Home] [Help]

APPS.PSB_LD_POS_DEFAULTS_PVT dependencies on PSB_POSITION_PAY_DISTRIBUTIONS

Line 77: FROM PSB_POSITION_PAY_DISTRIBUTIONS

73: chart_of_accounts_id,
74: code_combination_id,
75: distribution_percent,
76: distribution_default_rule_id
77: FROM PSB_POSITION_PAY_DISTRIBUTIONS
78: WHERE data_extract_id = p_data_extract_id
79: AND (((l_position_END_date is not NULL)
80: AND (((effective_start_date <= l_position_end_date)
81: AND (effective_END_date is NULL))

Line 98: FROM PSB_POSITION_PAY_DISTRIBUTIONS

94: -- pick the effective start date and end date for the local default rule which
95: -- will be applied
96: CURSOR l_eff_dates_csr is
97: SELECT effective_start_date, effective_end_date
98: FROM PSB_POSITION_PAY_DISTRIBUTIONS
99: WHERE position_id=l_position_id
100: AND project_id IS NOT NULL
101: AND code_combination_id IS NULL;
102: