APPS.PAY_EXA_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

    SELECT external_account_id,
           territory_code,
           prenote_date,
           id_flex_num,
           summary_flag,
           enabled_flag,
           start_date_active,
           end_date_active,
           segment1,
           segment2,
           segment3,
           segment4,
           segment5,
           segment6,
           segment7,
           segment8,
           segment9,
           segment10,
           segment11,
           segment12,
           segment13,
           segment14,
           segment15,
           segment16,
           segment17,
           segment18,
           segment19,
           segment20,
           segment21,
           segment22,
           segment23,
           segment24,
           segment25,
           segment26,
           segment27,
           segment28,
           segment29,
           segment30,
           object_version_number
    FROM   PAY_EXTERNAL_ACCOUNTS
    WHERE  external_account_id = p_external_account_id
    ;

Line: 179

    select
        external_account_id,
        territory_code,
        prenote_date,
        id_flex_num,
        summary_flag,
        enabled_flag,
        start_date_active,
        end_date_active,
        segment1,
        segment2,
        segment3,
        segment4,
        segment5,
        segment6,
        segment7,
        segment8,
        segment9,
        segment10,
        segment11,
        segment12,
        segment13,
        segment14,
        segment15,
        segment16,
        segment17,
        segment18,
        segment19,
        segment20,
        segment21,
        segment22,
        segment23,
        segment24,
        segment25,
        segment26,
        segment27,
        segment28,
        segment29,
        segment30,
        object_version_number
    from    pay_external_accounts
    where   external_account_id = p_external_account_id
    for update nowait;

Line: 419

    SELECT  fnd_number.canonical_to_number(plr.rule_mode)
	FROM    PAY_LEGISLATION_RULES plr,
		PER_BUSINESS_GROUPS   pbg
	WHERE   plr.rule_type         = 'E'
	and     p_territory_code is null
	and     plr.legislation_code  = pbg.legislation_code
	and     pbg.business_group_id = p_business_group_id
    Union
    SELECT  fnd_number.canonical_to_number(plr.rule_mode)
	FROM    PAY_LEGISLATION_RULES plr
	WHERE   plr.rule_type         = 'E'
	and     p_territory_code is not null
	and     plr.legislation_code  = p_territory_code;

Line: 461

    if p_dml_mode = 'INSERT' then
      hr_utility.trace('| doing insert interface processing');

Line: 511

    elsif p_dml_mode = 'UPDATE' then
      hr_utility.trace('| doing update interface processing');

Line: 610

                  select null
                  from   fnd_common_lookups
                  where  lookup_type = 'US_ACCOUNT_TYPE'
                  and    application_id = 800
                  and    lookup_code = p_segment2;

Line: 710

                  select null
                  from   hr_lookups
                  where  lookup_type = 'GB_BANKS'
                  and    lookup_code = p_segment1;

Line: 880

                  select null
                  from hr_lookups
                  where LOOKUP_TYPE = 'GB_COUNTRY'
                  and   lookup_code = p_segment8;