APPS.PAY_PPMV4_SS dependencies on FND_ID_FLEX_STRUCTURES

Line 1610: , fnd_id_flex_structures flex

1606: , flex.id_flex_structure_code
1607: into l_option_value
1608: , l_option_value1
1609: from pay_legislation_rules leg
1610: , fnd_id_flex_structures flex
1611: where leg.legislation_code = l_territory_code
1612: and leg.rule_type = 'E'
1613: and to_char(flex.id_flex_num) = leg.rule_mode
1614: and flex.id_flex_code = 'BANK';

Line 3621: , fnd_id_flex_structures flex

3617: cp_opm_id number
3618: ,cp_bgid number ) IS
3619: select flex.id_flex_structure_code
3620: from pay_legislation_rules leg
3621: , fnd_id_flex_structures flex
3622: , PAY_ORG_PAYMENT_METHODS_F opm
3623: , PAY_PAYMENT_TYPES PTS
3624: where opm.ORG_PAYMENT_METHOD_ID = cp_opm_id
3625: and opm.BUSINESS_GROUP_ID = cp_bgid

Line 3632: l_bank_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;

3628: and leg.rule_type = 'E'
3629: and to_char(flex.id_flex_num) = leg.rule_mode
3630: and flex.id_flex_code = 'BANK';
3631:
3632: l_bank_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
3633:
3634: begin
3635:
3636: OPEN c_get_flexcode(p_org_payment_method_id,p_business_group_id);