eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_POSITIONS_PVT dependencies on PSB_POSITIONS_PVT

Line 1: PACKAGE BODY PSB_POSITIONS_PVT AS

1: PACKAGE BODY PSB_POSITIONS_PVT AS
2: /* $Header: PSBVPOSB.pls 120.26 2006/02/17 12:40:34 matthoma ship $ */
3: --
4: -- Global Variables
5: --

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_POSITIONS_PVT';

3: --
4: -- Global Variables
5: --
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_POSITIONS_PVT';
8: G_DBUG VARCHAR2(2000);
9:
10: TYPE g_assign_rec_type IS RECORD
11: ( position_assignment_id NUMBER,

Line 1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

1529: and c.pay_element_id = pe2.pay_element_id
1530: and pe2.salary_flag = 'Y'
1531: and c.worksheet_id = p_worksheet_id
1532: and ( (
1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

Line 1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

1530: and pe2.salary_flag = 'Y'
1531: and c.worksheet_id = p_worksheet_id
1532: and ( (
1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

Line 1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

1531: and c.worksheet_id = p_worksheet_id
1532: and ( (
1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

Line 1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

1533: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1540: a.effective_start_date ))) )
1541: )

Line 1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

1534: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1540: a.effective_start_date ))) )
1541: )
1542: )

Line 1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

1535: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1536: c.effective_start_date ))) or (
1537: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
1538: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
1539: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
1540: a.effective_start_date ))) )
1541: )
1542: )
1543: )

Line 4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

4333: and c.pay_element_id = pe2.pay_element_id
4334: and pe2.salary_flag = 'Y'
4335: and c.worksheet_id = p_worksheet_id
4336: and ( (
4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

Line 4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

4334: and pe2.salary_flag = 'Y'
4335: and c.worksheet_id = p_worksheet_id
4336: and ( (
4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

Line 4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

4335: and c.worksheet_id = p_worksheet_id
4336: and ( (
4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

Line 4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between

4337: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4344: a.effective_start_date ))) )
4345: )

Line 4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and

4338: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4344: a.effective_start_date ))) )
4345: )
4346: )

Line 4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,

4339: nvl(a.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4340: c.effective_start_date ))) or (
4341: nvl(a.effective_start_date,PSB_POSITIONS_PVT.GET_end_date+1) between
4342: nvl(c.effective_start_date,PSB_POSITIONS_PVT.GET_end_date) and
4343: nvl(c.effective_end_date,nvl(PSB_POSITIONS_PVT.GET_end_date,
4344: a.effective_start_date ))) )
4345: )
4346: )
4347: )

Line 6403: END PSB_POSITIONS_PVT ;

6399:
6400: End Apply_Position_Default_Rules;
6401: /* Bug 1308558 End */
6402:
6403: END PSB_POSITIONS_PVT ;