APPS.PSB_ELEMENT_DISTRIBUTIONS_PVT dependencies on PSB_PAY_ELEMENT_DISTRIBUTIONS

Line 68: select ROWID from psb_pay_element_distributions

64: l_api_version CONSTANT NUMBER := 1.0;
65: l_row_id varchar2(40);
66: --
67: cursor c1 is
68: select ROWID from psb_pay_element_distributions
69: where distribution_id = p_distribution_id
70: and position_set_group_id = p_position_set_group_id
71: and chart_of_accounts_id = p_chart_of_accounts_id
72: and effective_start_date = p_effective_start_date;

Line 102: INSERT INTO psb_pay_element_distributions

98: p_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100:
101: -- API body
102: INSERT INTO psb_pay_element_distributions
103: (
104: DISTRIBUTION_ID ,
105: POSITION_SET_GROUP_ID ,
106: CHART_OF_ACCOUNTS_ID ,

Line 338: UPDATE psb_pay_element_distributions SET

334:
335: p_return_status := FND_API.G_RET_STS_SUCCESS;
336:
337: -- API body
338: UPDATE psb_pay_element_distributions SET
339: EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE,
340: EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
341: DISTRIBUTION_PERCENT = P_DISTRIBUTION_PERCENT,
342: CONCATENATED_SEGMENTS = P_CONCATENATED_SEGMENTS,

Line 481: DELETE FROM psb_pay_element_distributions

477: end if;
478:
479:
480: --Delete the record in the table
481: DELETE FROM psb_pay_element_distributions
482: where DISTRIBUTION_ID = P_DISTRIBUTION_ID
483: and POSITION_SET_GROUP_ID = P_POSITION_SET_GROUP_ID
484: and CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID
485: and EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE;

Line 599: CURSOR C IS SELECT * FROM PSB_PAY_ELEMENT_DISTRIBUTIONS

595: l_api_version CONSTANT NUMBER := 1.0;
596: --
597: counter number;
598:
599: CURSOR C IS SELECT * FROM PSB_PAY_ELEMENT_DISTRIBUTIONS
600: WHERE DISTRIBUTION_ID = P_DISTRIBUTION_ID
601: AND POSITION_SET_GROUP_ID = P_POSITION_SET_GROUP_ID
602: FOR UPDATE of DISTRIBUTION_Id NOWAIT;
603: Recinfo C%ROWTYPE;

Line 834: FROM psb_pay_element_distributions

830: l_tmp_ccid varchar2(1);
831:
832: CURSOR c_date IS
833: SELECT '1'
834: FROM psb_pay_element_distributions
835: WHERE ( (effective_start_date >= p_effective_start_date
836: AND effective_start_date <= p_effective_end_date)
837: OR (effective_end_date >= p_effective_start_date
838: AND effective_end_date <= p_effective_end_date) )

Line 844: FROM psb_pay_element_distributions

840: AND (distribution_set_id <> p_distribution_set_id);
841:
842: CURSOR c_ccid IS
843: SELECT '1'
844: FROM psb_pay_element_distributions
845: WHERE code_combination_id = p_code_combination_id
846: AND position_set_group_id = p_position_set_group_id
847: AND distribution_set_id = p_distribution_set_id;
848: