APPS.PJM_TRANSFER_CHARGES_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 985: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;

981:
982: -- Get Week Ending of Expenditure Item Date
983: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
984: into l_week_ending_day_index
985: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
986:
987: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
988: into l_week_ending_day from dual;
989:

Line 1418: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;

1414:
1415: -- Get Week Ending of Expenditure Item Date
1416: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
1417: into l_week_ending_day_index
1418: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
1419:
1420: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
1421: into l_week_ending_day from dual;
1422:

Line 1858: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;

1854:
1855: -- Get Week Ending of Expenditure Item Date
1856: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
1857: into l_week_ending_day_index
1858: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
1859:
1860: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
1861: into l_week_ending_day from dual;
1862:

Line 2287: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;

2283:
2284: -- Get Week Ending of Expenditure Item Date
2285: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
2286: into l_week_ending_day_index
2287: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
2288:
2289: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
2290: into l_week_ending_day from dual;
2291: