APPS.PSB_WS_POS2 dependencies on PSB_ALLOCRULE_PERCENTS

Line 3720: from PSB_ALLOCRULE_PERCENTS a,

3716: --there are more than one profiles with same priority
3717: cursor c_Monthly_Profile is
3718: select b.entity_id,
3719: a.percent
3720: from PSB_ALLOCRULE_PERCENTS a,
3721: PSB_DEFAULTS b
3722: where a.number_of_periods = 12
3723: and a.allocation_rule_id = b.entity_id
3724: and ((nvl(b.global_default_flag, 'N') = 'N'

Line 3741: from PSB_ALLOCRULE_PERCENTS a,

3737:
3738: cursor c_Quarterly_Profile is
3739: select b.entity_id,
3740: a.percent
3741: from PSB_ALLOCRULE_PERCENTS a,
3742: PSB_DEFAULTS b
3743: where a.number_of_periods = 4
3744: and a.allocation_rule_id = b.entity_id
3745: and ((nvl(b.global_default_flag, 'N') = 'N'

Line 3762: from PSB_ALLOCRULE_PERCENTS a,

3758:
3759: cursor c_Semiannual_Profile is
3760: select b.entity_id,
3761: a.percent
3762: from PSB_ALLOCRULE_PERCENTS a,
3763: PSB_DEFAULTS b
3764: where a.number_of_periods = 2
3765: and a.allocation_rule_id = b.entity_id
3766: and ((nvl(b.global_default_flag, 'N') = 'N'