APPS.PER_SIT_PKG dependencies on PER_PERSON_ANALYSES

Line 57: from per_person_analyses pa,

53: function sit_flex_used(p_bg_id number
54: ,p_id_flex_num number) return boolean is
55: cursor c is
56: select 'x'
57: from per_person_analyses pa,
58: per_special_info_types c
59: where pa.id_flex_num = c.id_flex_num
60: and pa.business_group_id = p_bg_id
61: and c.business_group_id = pa.business_group_id

Line 529: from per_person_analyses pa

525: and jr.position_id is not null;
526: --
527: cursor c_osha_analyses is
528: select 'X'
529: from per_person_analyses pa
530: where pa.id_flex_num = p_id_flex_num
531: and pa.business_group_id = p_business_group_id
532: and exists (select null
533: from pay_legislation_rules pl

Line 539: from per_person_analyses pa

535: and pl.rule_mode = to_char(pa.id_flex_num));
536: --
537: cursor c_ada_analyses is
538: select 'X'
539: from per_person_analyses pa
540: where pa.id_flex_num = p_id_flex_num
541: and pa.business_group_id = p_business_group_id
542: and exists (select null
543: from pay_legislation_rules pl

Line 549: from per_person_analyses pa

545: and pl.rule_mode = to_char(pa.id_flex_num));
546: --
547: cursor c_other_analyses is
548: select 'X'
549: from per_person_analyses pa
550: where pa.id_flex_num = p_id_flex_num
551: and pa.business_group_id = p_business_group_id
552: and not exists (select null
553: from pay_legislation_rules pl