[Home] [Help]
345: IF (l_include_exclude_payroll_flag = 'I') THEN
346: --
347: hr_utility.set_location('hr_listgen.build_payroll_list', 10);
348: --
349: INSERT INTO pay_payroll_list
350: (payroll_id,
351: security_profile_id,
352: request_id,
353: program_application_id,
371: ELSE -- exclude payrolls
372: --
373: hr_utility.set_location('hr_listgen.build_payroll_list', 20);
374: --
375: INSERT INTO pay_payroll_list
376: (payroll_id,
377: security_profile_id,
378: request_id,
379: program_application_id,
1364: fnd_dsql.add_text(', per_position_list pl ');
1365: end if;
1366:
1367: if p_sec_rec.view_all_payrolls_flag='N' then
1368: fnd_dsql.add_text( ' , pay_payroll_list ppl ');
1369: end if;*/
1370:
1371: if p_sec_rec.view_all_organizations_flag='Y' then
1372: null;
1442: fnd_dsql.add_bind(p_sec_rec.security_profile_id);
1443: fnd_dsql.add_text(' and ppl.payroll_id=ASSIGNMENT.payroll_id )');
1444: fnd_dsql.add_text(' or ASSIGNMENT.payroll_id is null )');*/
1445:
1446: fnd_dsql.add_text(' AND EXISTS ( SELECT /*+ use_nl(pay_payroll_list) */ 1 FROM pay_payroll_list');
1447: fnd_dsql.add_text(' WHERE (security_profile_id = ');
1448: fnd_dsql.add_bind(p_sec_rec.security_profile_id);
1449: fnd_dsql.add_text(' AND payroll_id=ASSIGNMENT.payroll_id ))');
1450: -- fnd_dsql.add_text(' OR ASSIGNMENT.payroll_id is null)');
2005: --
2006: hr_utility.set_location(l_proc, 40);
2007: -- Clearing Payroll static list
2008: delete
2009: from pay_payroll_list
2010: where security_profile_id = p_security_profile_id;
2011: --
2012: hr_utility.set_location('Leaving : '||l_proc, 99);
2013: --
2612: if g_debug then
2613: hr_utility.set_location(l_proc, 130);
2614: end if;
2615: l_from_str := ' from per_security_profiles sec,
2616: pay_payroll_list pay,
2617: per_organization_list org ';
2618: l_cond_str := ' org.security_profile_id = sec.security_profile_id
2619: and pay.security_profile_id = sec.security_profile_id
2620: and pay.security_profile_id = org.security_profile_id
2774: if g_debug then
2775: hr_utility.set_location(l_proc, 190);
2776: end if;
2777: l_from_str := ' from per_security_profiles sec,
2778: pay_payroll_list pay ';
2779: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
2780: and pay.payroll_id = :l_payroll_id
2781: and sec.view_all_organizations_flag = :l_all
2782: and sec.view_all_payrolls_flag = :l_Restrict and ';
3463: if g_debug then
3464: hr_utility.set_location(l_proc, 430);
3465: end if;
3466: l_from_str := ' from per_security_profiles sec,
3467: pay_payroll_list pay,
3468: per_position_list posl,
3469: per_organization_list org ';
3470: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3471: and posl.security_profile_id = sec.security_profile_id
3666: if g_debug then
3667: hr_utility.set_location(l_proc, 490);
3668: end if;
3669: l_from_str := ' from per_security_profiles sec,
3670: pay_payroll_list pay,
3671: per_organization_list org ';
3672: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3673: and pay.security_profile_id = sec.security_profile_id
3674: and org.organization_id = :l_organization_id
3758: if g_debug then
3759: hr_utility.set_location(l_proc, 520);
3760: end if;
3761: l_from_str := ' from per_security_profiles sec,
3762: pay_payroll_list pay,
3763: per_position_list posl ';
3764: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
3765: and pay.security_profile_id = sec.security_profile_id
3766: and pay.security_profile_id = posl.security_profile_id
4026: if g_debug then
4027: hr_utility.set_location(l_proc, 610);
4028: end if;
4029: l_from_str := ' from per_security_profiles sec,
4030: pay_payroll_list pay ';
4031: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
4032: and pay.payroll_id = :l_payroll_id
4033: and sec.view_all_organizations_flag = :l_all
4034: and sec.view_all_positions_flag = :l_all