APPS.PA_PAY_INTERFACE dependencies on DUAL

Line 395: SELECT sysdate INTO G_RUN_DATE FROM dual;

391: write_log (LOG, 'P_PERSON_ID -> ' || P_PERSON_ID);
392:
393:
394: -- SELECT org_id INTO G_ORG_ID FROM pa_implementations;
395: SELECT sysdate INTO G_RUN_DATE FROM dual;
396:
397: G_ORG_ID := FND_GLOBAL.ORG_ID;
398: G_USER_ID :=FND_GLOBAL.USER_ID;
399: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();

Line 2106: dual

2102: SELECT
2103: DECODE(psa.DISTRIBUTION_BASIS_CODE,'STHOURS' ,'ST',
2104: 'OTHOURS','OT','TOTAL_HOURS','ST')
2105: FROM
2106: dual
2107: UNION
2108: SELECT
2109: DECODE(psa.DISTRIBUTION_BASIS_CODE,'STHOURS' ,'ST',
2110: 'OTHOURS','OT','TOTAL_HOURS','OT')

Line 2112: dual

2108: SELECT
2109: DECODE(psa.DISTRIBUTION_BASIS_CODE,'STHOURS' ,'ST',
2110: 'OTHOURS','OT','TOTAL_HOURS','OT')
2111: FROM
2112: dual
2113: )
2114: AND NVL(EII.PROCESSED_FLAG,'N') <> 'Y' -- not processed in current run
2115: AND EII.INTERFACE_RUN_ID IS NULL; -- not an EI which has actual cost
2116:

Line 2278: DUAL

2274: (
2275: SELECT
2276: DECODE(PPSA.DISTRIBUTION_BASIS_CODE,'STHOURS' ,'ST', 'OTHOURS','OT','ALLHOURS','ST')
2277: FROM
2278: DUAL
2279: UNION
2280: SELECT
2281: DECODE(PPSA.DISTRIBUTION_BASIS_CODE,'STHOURS' ,'ST', 'OTHOURS','OT','ALLHOURS','OT')
2282: FROM

Line 2283: DUAL

2279: UNION
2280: SELECT
2281: DECODE(PPSA.DISTRIBUTION_BASIS_CODE,'STHOURS' ,'ST', 'OTHOURS','OT','ALLHOURS','OT')
2282: FROM
2283: DUAL
2284: )
2285: AND
2286: EI.EXPENDITURE_TYPE NOT IN
2287: (

Line 2474: FROM dual

2470: --AND COST_DISTRIBUTED_FLAG <> 'Y'
2471: -- No unprocessed timecard found .. shd go on already processed in prior runs
2472: AND SYSTEM_LINKAGE_FUNCTION IN
2473: (SELECT DECODE(X.distribution_basis_code,'STHOURS' ,'ST','OTHOURS','OT','ALLHOURS','ST')
2474: FROM dual
2475:
2476: UNION
2477:
2478: SELECT DECODE(X.distribution_basis_code,'STHOURS' ,'ST','OTHOURS','OT','ALLHOURS','OT')

Line 2479: FROM dual

2475:
2476: UNION
2477:
2478: SELECT DECODE(X.distribution_basis_code,'STHOURS' ,'ST','OTHOURS','OT','ALLHOURS','OT')
2479: FROM dual
2480: )
2481: AND expenditure_type NOT IN (SELECT expenditure_type FROM PA_PAY_EXCLUDE_EXP_TYPES
2482: WHERE pay_element_map_id = X.pay_element_map_id )
2483: GROUP BY NVL(organization_id ,OVERRIDE_TO_ORGANIZATION_ID) ,

Line 3144: from dual;

3140: p_job_id,
3141: p_org_id ORG_ID
3142: ,TO_CHAR(x_exp_item_date,'YYYY/MM/DD') expenditure_item_date
3143: ,p_organization_id orgj_id
3144: from dual;
3145:
3146: l_org_id_tab pa_plsql_datatypes.IdTabTyp;
3147: l_organization_id_tab pa_plsql_datatypes.IdTabTyp;
3148: l_person_id_tab pa_plsql_datatypes.IdTabTyp;

Line 3911: SELECT 'Y' INTO l_burden_exists FROM dual

3907:
3908:
3909: BEGIN
3910:
3911: SELECT 'Y' INTO l_burden_exists FROM dual
3912: WHERE EXISTS (SELECT 1
3913: FROM pa_pay_dist_lines
3914: WHERE SYSTEM_LINKAGE_FUNCTION = 'BTC'
3915: AND INTERFACE_RUN_ID = G_INTERFACE_RUN_ID

Line 3951: into l_expenditure_id from dual;

3947: AND PERSON_ID = G_PERSON_ID
3948: )
3949: LOOP
3950: select pa_expenditures_s.nextval
3951: into l_expenditure_id from dual;
3952:
3953: write_log(LOG,'Calling InsertExp' );
3954:
3955: pa_transactions.InsertExp(

Line 4034: into l_exp_item_id from dual;

4030: LOOP
4031:
4032: i := i+1;
4033: select pa_expenditure_items_s.nextval
4034: into l_exp_item_id from dual;
4035:
4036:
4037: --Validate
4038: write_log(LOG,'Calling Validate transaction for ' || Y.project_id || '-'|| Y.task_id|| '-'||Y.expenditure_type );

Line 4382: SELECT 'Y' INTO l_misc_exists FROM dual

4378:
4379: BEGIN
4380:
4381: BEGIN
4382: SELECT 'Y' INTO l_misc_exists FROM dual
4383: WHERE EXISTS (SELECT 1
4384: FROM pa_pay_dist_lines
4385: WHERE SYSTEM_LINKAGE_FUNCTION = 'PJ'
4386: AND INTERFACE_RUN_ID = G_INTERFACE_RUN_ID

Line 4433: into l_expenditure_id from dual;

4429: )
4430: LOOP
4431:
4432: select pa_expenditures_s.nextval
4433: into l_expenditure_id from dual;
4434:
4435: write_log(LOG,'Calling InsertExp for ' || X.organization_id || ' - ' || x.denom_currency_code );
4436:
4437: pa_transactions.InsertExp(

Line 4518: into l_exp_item_id from dual;

4514: LOOP
4515:
4516: i := i+1;
4517: select pa_expenditure_items_s.nextval
4518: into l_exp_item_id from dual;
4519:
4520:
4521:
4522:

Line 5654: G_REQUEST_ID FROM DUAL)*/

5650: (NVL ( ( SELECT EI1.PAYROLL_ACCRUAL_FLAG FROM
5651: PA_EXPENDITURE_ITEMS EI1 WHERE
5652: EI1.EXPENDITURE_ITEM_ID=EI2.ADJUSTED_EXPENDITURE_ITEM_ID),'N' )),
5653: --'N',
5654: G_REQUEST_ID FROM DUAL)*/
5655: NVL((-1*EI1.DENOM_RAW_COST),0),G_INTERFACE_RUN_ID,'ACTUAL',NVL(EI1.PAYROLL_ACCRUAL_FLAG,'N'),G_REQUEST_ID
5656: FROM PA_EXPENDITURE_ITEMS EI1
5657: WHERE
5658: EI1.EXPENDITURE_ITEM_ID=NVL(EI2.ADJUSTED_EXPENDITURE_ITEM_ID,EI2.EXPENDITURE_ITEM_ID))