APPS.PAY_PPR_BUS dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 31: , pay_status_processing_rules_f spr

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_status_processing_rules_f spr
32: where spr.status_processing_rule_id = p_status_processing_rule_id
33: and pbg.business_group_id (+) = spr.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pay_status_processing_rules_f spr

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pay_status_processing_rules_f spr
102: where spr.status_processing_rule_id = p_status_processing_rule_id
103: and pbg.business_group_id (+) = spr.business_group_id;
104: --
105: -- Declare local variables

Line 785: from pay_status_processing_rules_f

781: --
782: cursor c_duplicate_rule
783: is
784: select '1'
785: from pay_status_processing_rules_f
786: where nvl(assignment_status_type_id,-1) = nvl(p_assignment_status_type_id,-1)
787: and element_type_id = p_element_type_id
788: and processing_rule = nvl(p_processing_rule,'P')
789: and p_effective_date between effective_start_date

Line 923: l_processing_rule pay_status_processing_rules_f.processing_rule%type;

919: ,p_formula_mismatch_warning out nocopy boolean
920: ) is
921: --
922: l_proc varchar2(72) := g_package||'insert_validate';
923: l_processing_rule pay_status_processing_rules_f.processing_rule%type;
924: l_formula_mismatch_warning boolean;
925: --
926: Begin
927: hr_utility.set_location('Entering:'||l_proc, 5);