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.PA_UTILS dependencies on PA_IMPLEMENTATIONS

Line 287: pa_implementations i

283: INTO
284: X_org_id
285: FROM
286: hr_organization_units o,
287: pa_implementations i
288: WHERE name = X_org_name
289: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
290: AND o.business_group_id = i.business_group_id)
291: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'));

Line 322: pa_implementations i

318: INTO
319: X_orgn_id
320: FROM
321: hr_organization_units o,
322: pa_implementations i
323: WHERE name = X_org_name
324: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
325: AND o.business_group_id = i.business_group_id)
326: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'

Line 335: pa_implementations i

331: INTO
332: X_orgn_id
333: FROM
334: hr_organization_units o,
335: pa_implementations i
336: WHERE name = X_org_name
337: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
338: AND o.business_group_id = i.business_group_id)
339: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y' ));

Line 369: pa_implementations i

365: INTO
366: X_org_name
367: FROM
368: hr_organization_units o,
369: pa_implementations i
370: WHERE
371: organization_id = X_org_id
372: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
373: AND o.business_group_id = i.business_group_id)

Line 399: FROM pa_implementations;

395: BEGIN
396:
397: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
398: into X_week_ending_day_index
399: FROM pa_implementations;
400:
401: select to_char(to_date('01-01-1950','DD-MM-YYYY') +X_week_ending_day_index-1, 'Day')
402: into X_week_ending_day from dual;
403:

Line 503: FROM pa_implementations;

499: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here
500:
501: SELECT business_group_id --Moved selection of BG id from inside where clause to here
502: INTO X_business_group_id
503: FROM pa_implementations;
504:
505: SELECT
506: max(a.organization_id)
507: INTO

Line 714: FROM pa_implementations;

710: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here
711:
712: SELECT business_group_id --Moved selection of BG id from inside where clause to here
713: INTO X_business_group_id
714: FROM pa_implementations;
715:
716: If x_po_header_id is not null then --Bug 4044057
717:
718: hr_po_info.get_po_for_primary_asg(X_person_id, X_date,l_po_header_id,l_po_line_id);

Line 923: FROM pa_implementations;

919: X_business_group_id NUMBER(15);
920: BEGIN
921: SELECT DISTINCT business_group_id /*Distinct added for Bug 6043451*/
922: INTO X_business_group_id
923: FROM pa_implementations;
924:
925: RETURN(X_business_group_id);
926:
927: END business_group_id;

Line 1047: FROM pa_implementations_all

1043: INTO x_dummy
1044: FROM sys.dual
1045: WHERE EXISTS (
1046: SELECT NULL
1047: FROM pa_implementations_all
1048: WHERE org_id IS NOT NULL );
1049:
1050: IF ( x_dummy = 'Y' ) THEN
1051: RETURN( 'Y' );

Line 1241: with this procedure like no_data_found in pa_implementations.

1237: -- = FUNCTION Get_Org_Window_Title
1238: -- ==========================================================================
1239: /* These comments are added for bug 1812275.
1240: Please have a look at the solution provided in this bug if you face any issue
1241: with this procedure like no_data_found in pa_implementations.
1242: We are not suppressing any exceptions because and exception should be raised
1243: if there are no records found in pa_implementations
1244: */
1245:

Line 1243: if there are no records found in pa_implementations

1239: /* These comments are added for bug 1812275.
1240: Please have a look at the solution provided in this bug if you face any issue
1241: with this procedure like no_data_found in pa_implementations.
1242: We are not suppressing any exceptions because and exception should be raised
1243: if there are no records found in pa_implementations
1244: */
1245:
1246:
1247: FUNCTION Get_Org_Window_Title RETURN VARCHAR2

Line 1306: , pa_implementations c

1302: decode(l_multi_cur, 'N', NULL,
1303: ': ' || g.currency_code))
1304: into l_wnd_context
1305: from gl_sets_of_books g
1306: , pa_implementations c
1307: where c.set_of_books_id = g.set_of_books_id;
1308:
1309: /*
1310: ***

Line 1343: , pa_implementations c

1339: decode(l_multi_cur, 'N', NULL,
1340: ': ' || g.currency_code))
1341: into l_wnd_context
1342: from gl_sets_of_books g
1343: , pa_implementations c
1344: , hr_operating_units h
1345: where h.organization_id = to_number(l_id)
1346: and c.set_of_books_id = g.set_of_books_id;
1347:

Line 1603: , pa_implementations i

1599: X_Emp_Org_Id
1600: FROM
1601: per_assignment_status_types s
1602: , per_all_assignments_f a -- modified for Bug 4699231
1603: , pa_implementations i
1604: WHERE
1605: a.job_id IS NOT NULL
1606: AND a.primary_flag = 'Y'
1607: AND trunc(X_date) BETWEEN trunc( a.effective_start_date )

Line 1650: select exp_cycle_start_day_code into x_week_start from pa_implementations; /Bug 7601460 /

1646: BEGIN
1647:
1648: Begin
1649:
1650: select exp_cycle_start_day_code into x_week_start from pa_implementations; /*Bug 7601460 */
1651:
1652: -- Check if there are any records in the pl/sql table.
1653: If G_WeekEndDateTab.COUNT > 0 Then
1654:

Line 1685: FROM pa_implementations;

1681: End If;
1682:
1683: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
1684: into X_week_ending_day_index
1685: FROM pa_implementations;
1686:
1687: select to_char(to_date('01-01-1950','DD-MM-YYYY') +X_week_ending_day_index-1, 'Day')
1688: into X_week_ending_day
1689: from dual;