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.HZ_IMP_LOAD_PARTIES_PKG dependencies on FND_GLOBAL

Line 373: p_user_name => fnd_global.user_name,

369: hz_dss_util_pub.test_instance(
370: p_operation_code => 'UPDATE',
371: p_db_object_name => 'HZ_PARTIES',
372: p_instance_pk1_value => l_party_id(i),
373: p_user_name => fnd_global.user_name,
374: x_return_status => dss_return_status,
375: x_msg_count => dss_msg_count,
376: x_msg_data => dss_msg_data);
377:

Line 2085: fnd_global.resp_appl_id resp_appl_id,

2081: and person_iden_type_error is not null
2082: and createdby_error is not null
2083: then 1 else null end all_errors,
2084: sysdate mysysdate,
2085: fnd_global.resp_appl_id resp_appl_id,
2086: :13 l_actual_content_source,
2087: :14 l_content_source_type,
2088: :4 l_last_update_login,
2089: :5 l_program_application_id,

Line 2592: fnd_global.lookup_security_group(''PARTY_TYPE'', 222)

2588: and party_type_l.lookup_type (+) = ''PARTY_TYPE''
2589: and party_type_l.language (+) = userenv(''LANG'')
2590: and party_type_l.view_application_id (+) = 222
2591: and party_type_l.security_group_id (+) =
2592: fnd_global.lookup_security_group(''PARTY_TYPE'', 222)
2593: and month_l.lookup_code (+) = pi.fiscal_yearend_month
2594: and month_l.lookup_type (+) = ''MONTH''
2595: and month_l.language (+) = userenv(''LANG'')
2596: and month_l.view_application_id (+) = 222

Line 2598: fnd_global.lookup_security_group(''MONTH'', 222)

2594: and month_l.lookup_type (+) = ''MONTH''
2595: and month_l.language (+) = userenv(''LANG'')
2596: and month_l.view_application_id (+) = 222
2597: and month_l.security_group_id (+) =
2598: fnd_global.lookup_security_group(''MONTH'', 222)
2599: and legal_status_l.lookup_code (+) = pi.legal_status
2600: and legal_status_l.lookup_type (+) = ''LEGAL_STATUS''
2601: and legal_status_l.language (+) = userenv(''LANG'')
2602: and legal_status_l.view_application_id (+) = 222

Line 2604: fnd_global.lookup_security_group(''LEGAL_STATUS'', 222)

2600: and legal_status_l.lookup_type (+) = ''LEGAL_STATUS''
2601: and legal_status_l.language (+) = userenv(''LANG'')
2602: and legal_status_l.view_application_id (+) = 222
2603: and legal_status_l.security_group_id (+) =
2604: fnd_global.lookup_security_group(''LEGAL_STATUS'', 222)
2605: and local_bus_iden_type_l.lookup_code (+) = pi.local_bus_iden_type
2606: and local_bus_iden_type_l.lookup_type (+) = ''LOCAL_BUS_IDEN_TYPE''
2607: and local_bus_iden_type_l.language (+) = userenv(''LANG'')
2608: and local_bus_iden_type_l.view_application_id (+) = 222

Line 2610: fnd_global.lookup_security_group(''LOCAL_BUS_IDEN_TYPE'', 222)

2606: and local_bus_iden_type_l.lookup_type (+) = ''LOCAL_BUS_IDEN_TYPE''
2607: and local_bus_iden_type_l.language (+) = userenv(''LANG'')
2608: and local_bus_iden_type_l.view_application_id (+) = 222
2609: and local_bus_iden_type_l.security_group_id (+) =
2610: fnd_global.lookup_security_group(''LOCAL_BUS_IDEN_TYPE'', 222)
2611: and reg_type_l.lookup_code (+) = pi.registration_type
2612: and reg_type_l.lookup_type (+) = ''REGISTRATION_TYPE''
2613: and reg_type_l.language (+) = userenv(''LANG'')
2614: and reg_type_l.view_application_id (+) = 222

Line 2616: fnd_global.lookup_security_group(''REGISTRATION_TYPE'', 222)

2612: and reg_type_l.lookup_type (+) = ''REGISTRATION_TYPE''
2613: and reg_type_l.language (+) = userenv(''LANG'')
2614: and reg_type_l.view_application_id (+) = 222
2615: and reg_type_l.security_group_id (+) =
2616: fnd_global.lookup_security_group(''REGISTRATION_TYPE'', 222)
2617: and own_rent_l.lookup_code (+) = pi.rent_own_ind
2618: and own_rent_l.lookup_type (+) = ''OWN_RENT_IND''
2619: and own_rent_l.language (+) = userenv(''LANG'')
2620: and own_rent_l.view_application_id (+) = 222

Line 2622: fnd_global.lookup_security_group(''OWN_RENT_IND'', 222)

2618: and own_rent_l.lookup_type (+) = ''OWN_RENT_IND''
2619: and own_rent_l.language (+) = userenv(''LANG'')
2620: and own_rent_l.view_application_id (+) = 222
2621: and own_rent_l.security_group_id (+) =
2622: fnd_global.lookup_security_group(''OWN_RENT_IND'', 222)
2623: and hq_branch_l.lookup_code (+) = pi.hq_branch_ind
2624: and hq_branch_l.lookup_type (+) = ''HQ_BRANCH_IND''
2625: and hq_branch_l.language (+) = userenv(''LANG'')
2626: and hq_branch_l.view_application_id (+) = 222

Line 2628: fnd_global.lookup_security_group(''HQ_BRANCH_IND'', 222)

2624: and hq_branch_l.lookup_type (+) = ''HQ_BRANCH_IND''
2625: and hq_branch_l.language (+) = userenv(''LANG'')
2626: and hq_branch_l.view_application_id (+) = 222
2627: and hq_branch_l.security_group_id (+) =
2628: fnd_global.lookup_security_group(''HQ_BRANCH_IND'', 222)
2629: and tot_emp_est_l.lookup_code (+) = pi.total_emp_est_ind
2630: and tot_emp_est_l.lookup_type (+) = ''TOTAL_EMP_EST_IND''
2631: and tot_emp_est_l.language (+) = userenv(''LANG'')
2632: and tot_emp_est_l.view_application_id (+) = 222

Line 2634: fnd_global.lookup_security_group(''TOTAL_EMP_EST_IND'', 222)

2630: and tot_emp_est_l.lookup_type (+) = ''TOTAL_EMP_EST_IND''
2631: and tot_emp_est_l.language (+) = userenv(''LANG'')
2632: and tot_emp_est_l.view_application_id (+) = 222
2633: and tot_emp_est_l.security_group_id (+) =
2634: fnd_global.lookup_security_group(''TOTAL_EMP_EST_IND'', 222)
2635: and tot_emp_min_l.lookup_code (+) = pi.total_emp_min_ind
2636: and tot_emp_min_l.lookup_type (+) = ''TOTAL_EMP_MIN_IND''
2637: and tot_emp_min_l.language (+) = userenv(''LANG'')
2638: and tot_emp_min_l.view_application_id (+) = 222

Line 2640: fnd_global.lookup_security_group(''TOTAL_EMP_MIN_IND'', 222)

2636: and tot_emp_min_l.lookup_type (+) = ''TOTAL_EMP_MIN_IND''
2637: and tot_emp_min_l.language (+) = userenv(''LANG'')
2638: and tot_emp_min_l.view_application_id (+) = 222
2639: and tot_emp_min_l.security_group_id (+) =
2640: fnd_global.lookup_security_group(''TOTAL_EMP_MIN_IND'', 222)
2641: and tot_emp_ind_l.lookup_code (+) = pi.total_employees_ind
2642: and tot_emp_ind_l.lookup_type (+) = ''TOTAL_EMPLOYEES_INDICATOR''
2643: and tot_emp_ind_l.language (+) = userenv(''LANG'')
2644: and tot_emp_ind_l.view_application_id (+) = 222

Line 2646: fnd_global.lookup_security_group(''TOTAL_EMPLOYEES_INDICATOR'', 222)

2642: and tot_emp_ind_l.lookup_type (+) = ''TOTAL_EMPLOYEES_INDICATOR''
2643: and tot_emp_ind_l.language (+) = userenv(''LANG'')
2644: and tot_emp_ind_l.view_application_id (+) = 222
2645: and tot_emp_ind_l.security_group_id (+) =
2646: fnd_global.lookup_security_group(''TOTAL_EMPLOYEES_INDICATOR'', 222)
2647: and emp_at_pri_adr_est_ind_l.lookup_code (+) = pi.emp_at_primary_adr_est_ind
2648: and emp_at_pri_adr_est_ind_l.lookup_type (+) = ''EMP_AT_PRIMARY_ADR_EST_IND''
2649: and emp_at_pri_adr_est_ind_l.language (+) = userenv(''LANG'')
2650: and emp_at_pri_adr_est_ind_l.view_application_id (+) = 222

Line 2652: fnd_global.lookup_security_group(''EMP_AT_PRIMARY_ADR_EST_IND'', 222)

2648: and emp_at_pri_adr_est_ind_l.lookup_type (+) = ''EMP_AT_PRIMARY_ADR_EST_IND''
2649: and emp_at_pri_adr_est_ind_l.language (+) = userenv(''LANG'')
2650: and emp_at_pri_adr_est_ind_l.view_application_id (+) = 222
2651: and emp_at_pri_adr_est_ind_l.security_group_id (+) =
2652: fnd_global.lookup_security_group(''EMP_AT_PRIMARY_ADR_EST_IND'', 222)
2653: and emp_at_pri_adr_min_ind_l.lookup_code (+) = pi.emp_at_primary_adr_min_ind
2654: and emp_at_pri_adr_min_ind_l.lookup_type (+) = ''EMP_AT_PRIMARY_ADR_MIN_IND''
2655: and emp_at_pri_adr_min_ind_l.language (+) = userenv(''LANG'')
2656: and emp_at_pri_adr_min_ind_l.view_application_id (+) = 222

Line 2658: fnd_global.lookup_security_group(''EMP_AT_PRIMARY_ADR_MIN_IND'', 222)

2654: and emp_at_pri_adr_min_ind_l.lookup_type (+) = ''EMP_AT_PRIMARY_ADR_MIN_IND''
2655: and emp_at_pri_adr_min_ind_l.language (+) = userenv(''LANG'')
2656: and emp_at_pri_adr_min_ind_l.view_application_id (+) = 222
2657: and emp_at_pri_adr_min_ind_l.security_group_id (+) =
2658: fnd_global.lookup_security_group(''EMP_AT_PRIMARY_ADR_MIN_IND'', 222)
2659: and marital_status_l.lookup_code (+) = pi.marital_status
2660: and marital_status_l.lookup_type (+) = ''MARITAL_STATUS''
2661: and marital_status_l.language (+) = userenv(''LANG'')
2662: and marital_status_l.view_application_id (+) = 222

Line 2664: fnd_global.lookup_security_group(''MARITAL_STATUS'', 222)

2660: and marital_status_l.lookup_type (+) = ''MARITAL_STATUS''
2661: and marital_status_l.language (+) = userenv(''LANG'')
2662: and marital_status_l.view_application_id (+) = 222
2663: and marital_status_l.security_group_id (+) =
2664: fnd_global.lookup_security_group(''MARITAL_STATUS'', 222)
2665: and contact_title_l.lookup_code (+) = pi.person_pre_name_adjunct
2666: and contact_title_l.lookup_type (+) = ''CONTACT_TITLE''
2667: and contact_title_l.language (+) = userenv(''LANG'')
2668: and contact_title_l.view_application_id (+) = 222

Line 2670: fnd_global.lookup_security_group(''CONTACT_TITLE'', 222)

2666: and contact_title_l.lookup_type (+) = ''CONTACT_TITLE''
2667: and contact_title_l.language (+) = userenv(''LANG'')
2668: and contact_title_l.view_application_id (+) = 222
2669: and contact_title_l.security_group_id (+) =
2670: fnd_global.lookup_security_group(''CONTACT_TITLE'', 222)
2671: and gender_l.lookup_code (+) = pi.gender
2672: and gender_l.lookup_type (+) = ''HZ_GENDER''
2673: and gender_l.language (+) = userenv(''LANG'')
2674: and gender_l.view_application_id (+) = 222

Line 2676: fnd_global.lookup_security_group(''HZ_GENDER'', 222)

2672: and gender_l.lookup_type (+) = ''HZ_GENDER''
2673: and gender_l.language (+) = userenv(''LANG'')
2674: and gender_l.view_application_id (+) = 222
2675: and gender_l.security_group_id (+) =
2676: fnd_global.lookup_security_group(''HZ_GENDER'', 222)
2677: and person_iden_type_l.lookup_code (+) = pi.person_iden_type
2678: and person_iden_type_l.lookup_type (+) = ''HZ_PERSON_IDEN_TYPE''
2679: and person_iden_type_l.language (+) = userenv(''LANG'')
2680: and person_iden_type_l.view_application_id (+) = 222

Line 2682: fnd_global.lookup_security_group(''HZ_PERSON_IDEN_TYPE'', 222)

2678: and person_iden_type_l.lookup_type (+) = ''HZ_PERSON_IDEN_TYPE''
2679: and person_iden_type_l.language (+) = userenv(''LANG'')
2680: and person_iden_type_l.view_application_id (+) = 222
2681: and person_iden_type_l.security_group_id (+) =
2682: fnd_global.lookup_security_group(''HZ_PERSON_IDEN_TYPE'', 222)
2683: and createdby_l.lookup_code (+) = pi.created_by_module
2684: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
2685: and createdby_l.language (+) = userenv(''LANG'')
2686: and createdby_l.view_application_id (+) = 222

Line 2688: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)

2684: and createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
2685: and createdby_l.language (+) = userenv(''LANG'')
2686: and createdby_l.view_application_id (+) = 222
2687: and createdby_l.security_group_id (+) =
2688: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
2689: and ps.batch_id = :12
2690: and ps.party_orig_system = :20
2691: and ps.party_orig_system_reference between :21 and :22
2692: and ps.batch_mode_flag = :19

Line 3263: fnd_global.lookup_security_group(''PARTY_TYPE'', 222)

3259: AND party_type_l.lookup_type (+) = ''PARTY_TYPE''
3260: AND party_type_l.language (+) = userenv(''LANG'')
3261: AND party_type_l.view_application_id (+) = 222
3262: AND party_type_l.security_group_id (+) =
3263: fnd_global.lookup_security_group(''PARTY_TYPE'', 222)
3264: AND month_l.lookup_code (+) = pi.fiscal_yearend_month
3265: AND month_l.lookup_type (+) = ''MONTH''
3266: AND month_l.language (+) = userenv(''LANG'')
3267: AND month_l.view_application_id (+) = 222

Line 3269: fnd_global.lookup_security_group(''MONTH'', 222)

3265: AND month_l.lookup_type (+) = ''MONTH''
3266: AND month_l.language (+) = userenv(''LANG'')
3267: AND month_l.view_application_id (+) = 222
3268: AND month_l.security_group_id (+) =
3269: fnd_global.lookup_security_group(''MONTH'', 222)
3270: AND legal_status_l.lookup_code (+) = pi.legal_status
3271: AND legal_status_l.lookup_type (+) = ''LEGAL_STATUS''
3272: AND legal_status_l.language (+) = userenv(''LANG'')
3273: AND legal_status_l.view_application_id (+) = 222

Line 3275: fnd_global.lookup_security_group(''LEGAL_STATUS'', 222)

3271: AND legal_status_l.lookup_type (+) = ''LEGAL_STATUS''
3272: AND legal_status_l.language (+) = userenv(''LANG'')
3273: AND legal_status_l.view_application_id (+) = 222
3274: AND legal_status_l.security_group_id (+) =
3275: fnd_global.lookup_security_group(''LEGAL_STATUS'', 222)
3276: AND local_bus_iden_type_l.lookup_code (+) = pi.local_bus_iden_type
3277: AND local_bus_iden_type_l.lookup_type (+) = ''LOCAL_BUS_IDEN_TYPE''
3278: AND local_bus_iden_type_l.language (+) = userenv(''LANG'')
3279: AND local_bus_iden_type_l.view_application_id (+) = 222

Line 3281: fnd_global.lookup_security_group(''LOCAL_BUS_IDEN_TYPE'', 222)

3277: AND local_bus_iden_type_l.lookup_type (+) = ''LOCAL_BUS_IDEN_TYPE''
3278: AND local_bus_iden_type_l.language (+) = userenv(''LANG'')
3279: AND local_bus_iden_type_l.view_application_id (+) = 222
3280: AND local_bus_iden_type_l.security_group_id (+) =
3281: fnd_global.lookup_security_group(''LOCAL_BUS_IDEN_TYPE'', 222)
3282: AND reg_type_l.lookup_code (+) = pi.registration_type
3283: AND reg_type_l.lookup_type (+) = ''REGISTRATION_TYPE''
3284: AND reg_type_l.language (+) = userenv(''LANG'')
3285: AND reg_type_l.view_application_id (+) = 222

Line 3287: fnd_global.lookup_security_group(''REGISTRATION_TYPE'', 222)

3283: AND reg_type_l.lookup_type (+) = ''REGISTRATION_TYPE''
3284: AND reg_type_l.language (+) = userenv(''LANG'')
3285: AND reg_type_l.view_application_id (+) = 222
3286: AND reg_type_l.security_group_id (+) =
3287: fnd_global.lookup_security_group(''REGISTRATION_TYPE'', 222)
3288: AND own_rent_l.lookup_code (+) = pi.rent_own_ind
3289: AND own_rent_l.lookup_type (+) = ''OWN_RENT_IND''
3290: AND own_rent_l.language (+) = userenv(''LANG'')
3291: AND own_rent_l.view_application_id (+) = 222

Line 3293: fnd_global.lookup_security_group(''OWN_RENT_IND'', 222)

3289: AND own_rent_l.lookup_type (+) = ''OWN_RENT_IND''
3290: AND own_rent_l.language (+) = userenv(''LANG'')
3291: AND own_rent_l.view_application_id (+) = 222
3292: AND own_rent_l.security_group_id (+) =
3293: fnd_global.lookup_security_group(''OWN_RENT_IND'', 222)
3294: AND hq_branch_l.lookup_code (+) = pi.hq_branch_ind
3295: AND hq_branch_l.lookup_type (+) = ''HQ_BRANCH_IND''
3296: AND hq_branch_l.language (+) = userenv(''LANG'')
3297: AND hq_branch_l.view_application_id (+) = 222

Line 3299: fnd_global.lookup_security_group(''HQ_BRANCH_IND'', 222)

3295: AND hq_branch_l.lookup_type (+) = ''HQ_BRANCH_IND''
3296: AND hq_branch_l.language (+) = userenv(''LANG'')
3297: AND hq_branch_l.view_application_id (+) = 222
3298: AND hq_branch_l.security_group_id (+) =
3299: fnd_global.lookup_security_group(''HQ_BRANCH_IND'', 222)
3300: AND tot_emp_est_l.lookup_code (+) = pi.total_emp_est_ind
3301: AND tot_emp_est_l.lookup_type (+) = ''TOTAL_EMP_EST_IND''
3302: AND tot_emp_est_l.language (+) = userenv(''LANG'')
3303: AND tot_emp_est_l.view_application_id (+) = 222

Line 3305: fnd_global.lookup_security_group(''TOTAL_EMP_EST_IND'', 222)

3301: AND tot_emp_est_l.lookup_type (+) = ''TOTAL_EMP_EST_IND''
3302: AND tot_emp_est_l.language (+) = userenv(''LANG'')
3303: AND tot_emp_est_l.view_application_id (+) = 222
3304: AND tot_emp_est_l.security_group_id (+) =
3305: fnd_global.lookup_security_group(''TOTAL_EMP_EST_IND'', 222)
3306: AND tot_emp_min_l.lookup_code (+) = pi.total_emp_min_ind
3307: AND tot_emp_min_l.lookup_type (+) = ''TOTAL_EMP_MIN_IND''
3308: AND tot_emp_min_l.language (+) = userenv(''LANG'')
3309: AND tot_emp_min_l.view_application_id (+) = 222

Line 3311: fnd_global.lookup_security_group(''TOTAL_EMP_MIN_IND'', 222)

3307: AND tot_emp_min_l.lookup_type (+) = ''TOTAL_EMP_MIN_IND''
3308: AND tot_emp_min_l.language (+) = userenv(''LANG'')
3309: AND tot_emp_min_l.view_application_id (+) = 222
3310: AND tot_emp_min_l.security_group_id (+) =
3311: fnd_global.lookup_security_group(''TOTAL_EMP_MIN_IND'', 222)
3312: AND tot_emp_ind_l.lookup_code (+) = pi.total_employees_ind
3313: AND tot_emp_ind_l.lookup_type (+) = ''TOTAL_EMPLOYEES_INDICATOR''
3314: AND tot_emp_ind_l.language (+) = userenv(''LANG'')
3315: AND tot_emp_ind_l.view_application_id (+) = 222

Line 3317: fnd_global.lookup_security_group(''TOTAL_EMPLOYEES_INDICATOR'', 222)

3313: AND tot_emp_ind_l.lookup_type (+) = ''TOTAL_EMPLOYEES_INDICATOR''
3314: AND tot_emp_ind_l.language (+) = userenv(''LANG'')
3315: AND tot_emp_ind_l.view_application_id (+) = 222
3316: AND tot_emp_ind_l.security_group_id (+) =
3317: fnd_global.lookup_security_group(''TOTAL_EMPLOYEES_INDICATOR'', 222)
3318: AND emp_at_pri_adr_est_ind_l.lookup_code (+) = pi.emp_at_primary_adr_est_ind
3319: AND emp_at_pri_adr_est_ind_l.lookup_type (+) = ''EMP_AT_PRIMARY_ADR_EST_IND''
3320: AND emp_at_pri_adr_est_ind_l.language (+) = userenv(''LANG'')
3321: AND emp_at_pri_adr_est_ind_l.view_application_id (+) = 222

Line 3323: fnd_global.lookup_security_group(''EMP_AT_PRIMARY_ADR_EST_IND'', 222)

3319: AND emp_at_pri_adr_est_ind_l.lookup_type (+) = ''EMP_AT_PRIMARY_ADR_EST_IND''
3320: AND emp_at_pri_adr_est_ind_l.language (+) = userenv(''LANG'')
3321: AND emp_at_pri_adr_est_ind_l.view_application_id (+) = 222
3322: AND emp_at_pri_adr_est_ind_l.security_group_id (+) =
3323: fnd_global.lookup_security_group(''EMP_AT_PRIMARY_ADR_EST_IND'', 222)
3324: AND emp_at_pri_adr_min_ind_l.lookup_code (+) = pi.emp_at_primary_adr_min_ind
3325: AND emp_at_pri_adr_min_ind_l.lookup_type (+) = ''EMP_AT_PRIMARY_ADR_MIN_IND''
3326: AND emp_at_pri_adr_min_ind_l.language (+) = userenv(''LANG'')
3327: AND emp_at_pri_adr_min_ind_l.view_application_id (+) = 222

Line 3329: fnd_global.lookup_security_group(''EMP_AT_PRIMARY_ADR_MIN_IND'', 222)

3325: AND emp_at_pri_adr_min_ind_l.lookup_type (+) = ''EMP_AT_PRIMARY_ADR_MIN_IND''
3326: AND emp_at_pri_adr_min_ind_l.language (+) = userenv(''LANG'')
3327: AND emp_at_pri_adr_min_ind_l.view_application_id (+) = 222
3328: AND emp_at_pri_adr_min_ind_l.security_group_id (+) =
3329: fnd_global.lookup_security_group(''EMP_AT_PRIMARY_ADR_MIN_IND'', 222)
3330: AND marital_status_l.lookup_code (+) = pi.marital_status
3331: AND marital_status_l.lookup_type (+) = ''MARITAL_STATUS''
3332: AND marital_status_l.language (+) = userenv(''LANG'')
3333: AND marital_status_l.view_application_id (+) = 222

Line 3335: fnd_global.lookup_security_group(''MARITAL_STATUS'', 222)

3331: AND marital_status_l.lookup_type (+) = ''MARITAL_STATUS''
3332: AND marital_status_l.language (+) = userenv(''LANG'')
3333: AND marital_status_l.view_application_id (+) = 222
3334: AND marital_status_l.security_group_id (+) =
3335: fnd_global.lookup_security_group(''MARITAL_STATUS'', 222)
3336: AND contact_title_l.lookup_code (+) = pi.person_pre_name_adjunct
3337: AND contact_title_l.lookup_type (+) = ''CONTACT_TITLE''
3338: AND contact_title_l.language (+) = userenv(''LANG'')
3339: AND contact_title_l.view_application_id (+) = 222

Line 3341: fnd_global.lookup_security_group(''CONTACT_TITLE'', 222)

3337: AND contact_title_l.lookup_type (+) = ''CONTACT_TITLE''
3338: AND contact_title_l.language (+) = userenv(''LANG'')
3339: AND contact_title_l.view_application_id (+) = 222
3340: AND contact_title_l.security_group_id (+) =
3341: fnd_global.lookup_security_group(''CONTACT_TITLE'', 222)
3342: AND gender_l.lookup_code (+) = pi.gender
3343: AND gender_l.lookup_type (+) = ''HZ_GENDER''
3344: AND gender_l.language (+) = userenv(''LANG'')
3345: AND gender_l.view_application_id (+) = 222

Line 3347: fnd_global.lookup_security_group(''HZ_GENDER'', 222)

3343: AND gender_l.lookup_type (+) = ''HZ_GENDER''
3344: AND gender_l.language (+) = userenv(''LANG'')
3345: AND gender_l.view_application_id (+) = 222
3346: AND gender_l.security_group_id (+) =
3347: fnd_global.lookup_security_group(''HZ_GENDER'', 222)
3348: AND person_iden_type_l.lookup_code (+) = pi.person_iden_type
3349: AND person_iden_type_l.lookup_type (+) = ''HZ_PERSON_IDEN_TYPE''
3350: AND person_iden_type_l.language (+) = userenv(''LANG'')
3351: AND person_iden_type_l.view_application_id (+) = 222

Line 3353: fnd_global.lookup_security_group(''HZ_PERSON_IDEN_TYPE'', 222)

3349: AND person_iden_type_l.lookup_type (+) = ''HZ_PERSON_IDEN_TYPE''
3350: AND person_iden_type_l.language (+) = userenv(''LANG'')
3351: AND person_iden_type_l.view_application_id (+) = 222
3352: AND person_iden_type_l.security_group_id (+) =
3353: fnd_global.lookup_security_group(''HZ_PERSON_IDEN_TYPE'', 222)
3354: AND createdby_l.lookup_type (+) = ''HZ_CREATED_BY_MODULES''
3355: AND createdby_l.lookup_code (+) = pi.created_by_module
3356: AND createdby_l.language (+) = userenv(''LANG'')
3357: AND createdby_l.view_application_id (+) = 222

Line 3359: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)

3355: AND createdby_l.lookup_code (+) = pi.created_by_module
3356: AND createdby_l.language (+) = userenv(''LANG'')
3357: AND createdby_l.view_application_id (+) = 222
3358: AND createdby_l.security_group_id (+) =
3359: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
3360: AND ps.batch_id = :P_BATCH_ID
3361: AND ps.party_orig_system = :P_OS
3362: AND ps.party_orig_system_reference between :P_FROM_OSR and :P_TO_OSR
3363: AND ps.batch_mode_flag = :P_BATCH_MODE_FLAG

Line 9439: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,

9435: (SELECT
9436: 'THIRD_PARTY' PARTY_TYPE_CODE,
9437: party.party_id PARTY_ID,
9438: party.country COUNTRY_CODE,--4742586
9439: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
9440: party.tax_reference TAX_REFERENCE,
9441: SYSDATE CREATION_DATE,
9442: FND_GLOBAL.User_ID CREATED_BY,
9443: SYSDATE LAST_UPDATE_DATE,

Line 9442: FND_GLOBAL.User_ID CREATED_BY,

9438: party.country COUNTRY_CODE,--4742586
9439: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
9440: party.tax_reference TAX_REFERENCE,
9441: SYSDATE CREATION_DATE,
9442: FND_GLOBAL.User_ID CREATED_BY,
9443: SYSDATE LAST_UPDATE_DATE,
9444: FND_GLOBAL.User_ID LAST_UPDATED_BY,
9445: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
9446: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint

Line 9444: FND_GLOBAL.User_ID LAST_UPDATED_BY,

9440: party.tax_reference TAX_REFERENCE,
9441: SYSDATE CREATION_DATE,
9442: FND_GLOBAL.User_ID CREATED_BY,
9443: SYSDATE LAST_UPDATE_DATE,
9444: FND_GLOBAL.User_ID LAST_UPDATED_BY,
9445: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
9446: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint
9447: WHERE party.request_id = p_request_id
9448: AND party.party_id = ps.party_id

Line 9445: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN

9441: SYSDATE CREATION_DATE,
9442: FND_GLOBAL.User_ID CREATED_BY,
9443: SYSDATE LAST_UPDATE_DATE,
9444: FND_GLOBAL.User_ID LAST_UPDATED_BY,
9445: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
9446: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint
9447: WHERE party.request_id = p_request_id
9448: AND party.party_id = ps.party_id
9449: AND ps.batch_mode_flag = p_batch_mode_flag