APPS.PAY_PPMV4_SS dependencies on FND_ID_FLEX_STRUCTURES

Line 1685: , fnd_id_flex_structures flex

1681: , flex.id_flex_structure_code
1682: into l_option_value
1683: , l_option_value1
1684: from pay_legislation_rules leg
1685: , fnd_id_flex_structures flex
1686: where leg.legislation_code = l_territory_code
1687: and leg.rule_type = 'E'
1688: and to_char(flex.id_flex_num) = leg.rule_mode
1689: and flex.id_flex_code = 'BANK';

Line 3957: , fnd_id_flex_structures flex

3953: cp_opm_id number
3954: ,cp_bgid number ) IS
3955: select flex.id_flex_structure_code
3956: from pay_legislation_rules leg
3957: , fnd_id_flex_structures flex
3958: , PAY_ORG_PAYMENT_METHODS_F opm
3959: , PAY_PAYMENT_TYPES PTS
3960: where opm.ORG_PAYMENT_METHOD_ID = cp_opm_id
3961: and opm.BUSINESS_GROUP_ID = cp_bgid

Line 3968: l_bank_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;

3964: and leg.rule_type = 'E'
3965: and to_char(flex.id_flex_num) = leg.rule_mode
3966: and flex.id_flex_code = 'BANK';
3967:
3968: l_bank_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
3969:
3970: begin
3971:
3972: OPEN c_get_flexcode(p_org_payment_method_id,p_business_group_id);