DBA Data[Home] [Help]

APPS.PSB_POSITION_PAY_DISTR_PVT dependencies on DUAL

Line 1434: from dual;

1430: l_dis_overlap VARCHAR2(1):= FND_API.G_FALSE;
1431:
1432: cursor c_Seq is
1433: select psb_position_pay_distr_s.nextval DistID
1434: from dual;
1435:
1436: cursor c_Dist is
1437: select distribution_id,
1438: position_id,

Line 2191: from dual;

2187: l_distr_found VARCHAR2(1) := FND_API.G_FALSE;
2188:
2189: cursor c_Seq is
2190: select psb_position_pay_distr_s.nextval DistID
2191: from dual;
2192:
2193: cursor c_overlap is
2194: select distribution_id
2195: from PSB_POSITION_PAY_DISTRIBUTIONS

Line 2311: from dual;

2307: and worksheet_id is null;
2308:
2309: cursor c_Seq is
2310: select psb_position_pay_distr_s.nextval DistID
2311: from dual;
2312:
2313: l_distribution_id NUMBER;
2314: del_flag VARCHAR2(1);
2315: l_return_status VARCHAR2(1);

Line 2639: FROM dual;

2635: l_ccid_exists BOOLEAN:=FALSE;
2636:
2637: CURSOR c_Seq IS
2638: SELECT psb_position_pay_distr_s.NEXTVAL DistID
2639: FROM dual;
2640:
2641: CURSOR c_Dist IS
2642: SELECT distribution_id,
2643: position_id,